nls_dual_currency

Description

The nls_dual_currency variable specifies the local currency symbol for the U numeric format element.

Privilege requirements

• Query variables

  • Global level

    Both the sys tenant and all user tenants can execute the SHOW VARIABLES statement or query the SYS.TENANT_VIRTUAL_GLOBAL_VARIABLE view (in Oracle-compatible mode) to query the values of global system variables.

  • Session level

    Both the sys tenant and all user tenants can execute the SHOW VARIABLES statement or query the SYS.TENANT_VIRTUAL_SESSION_VARIABLE view (in Oracle-compatible mode) to query the values of session system variables.

• Modify variables

  Neither the sys tenant nor any user tenants can modify the values of global or session system variables in their own tenants.

Attributes