List of Territories Supported by Oracle Database

Below is a list of territories that are supported by Oracle Database. These can be used when setting the NLS_TERRITORY initialization parameter.

You can check the value of your session’s NLS_TERRITORY parameter like this:

SELECT VALUE
FROM V$NLS_PARAMETERS
WHERE PARAMETER = 'NLS_TERRITORY';

You can set the parameter like this:

ALTER SESSION SET NLS_TERRITORY = 'AUSTRALIA';

This example sets the value to AUSTRALIA, but you can use any of the territories listed above.

You can also get a list of territories by querying the V$NLS_VALID_VALUES view:

SELECT * FROM
V$NLS_VALID_VALUES
WHERE PARAMETER = 'TERRITORY'
ORDER BY VALUE ASC;