Updated on 2025-03-13 GMT+08:00

NLS_DATABASE_PARAMETERS

NLS_DATABASE_PARAMETERS lists the permanent NLS parameters of the database server. This view exists in both 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 this view may be obviously different from those in the database A.

Table 1 NLS_DATABASE_PARAMETERS columns

Name

Type

Description

parameter

character varying(128)

Parameter name.

value

character varying(64)

Parameter value.