Updated on 2024-05-07 GMT+08:00

NLS_INSTANCE_PARAMETERS

NLS_INSTANCE_PARAMETERS lists the permanent NLS parameters of the database client. This view exists in both PG_CATALOG and SYS schema. It is accessible to all users. Due to different database kernels and parameter setting formats, the query results of the same parameters in this view may be obviously different from those in the database A.

Table 1 NLS_INSTANCE_PARAMETERS columns

Name

Type

Description

parameter

character varying(128)

Parameter name.

value

character varying(64)

Parameter value.