Globalization Support Parameters in Views (178)

When Oracle evaluates views containing string literals or SQL functions that have
globalization support parameters as arguments (such as TO_CHAR, TO_DATE, and TO_
NUMBER), Oracle takes default values for these parameters from the globalization
support parameters for the session. You can override these default values by
specifying globalization support parameters explicitly in the view definition.

檢視中的國際化支援引數
當 Oracle 發現檢視中存在使用國際化支援引數的 SQL 函式或字串型符號時,
Oracle將使用當前會話的國際化支援引數作為其預設引數.
使用者也可以在檢視的定義中顯式地設定國際化支援引數,從而覆蓋預設引數.

[@more@]