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

NLS_DATABASE_PARAMETERS

NLS_DATABASE_PARAMETERS lists the permanent NLS parameters of the database server. 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_DATABASE_PARAMETERS columns

Name

Type

Description

parameter

character varying(128)

Parameter name

value

character varying(64)

Parameter value