Updated on 2024-06-03 GMT+08:00

NLS_INSTANCE_PARAMETERS

NLS_INSTANCE_PARAMETERS lists the permanent NLS parameters of the database client. This view exists in the PG_CATALOG and SYS schemas. It is accessible to all users. Due to different database kernels and parameter setting formats, the query results of the same parameters in the database 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