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 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 the database may be obviously different from those in the ORA database.

Table 1 NLS_INSTANCE_PARAMETERS columns

Name

Type

Description

parameter

character varying(128)

Parameter name

value

character varying(64)

Parameter value