Wednesday, May 14, 2008

What is territory support in Oracle 10g?

It sets globalization defaults for
• day and week numbering
• credit and debit symbols
• date formats
• decimal and group numeric separators
• currency symbols

Useful Data Dictionary: v$nls_valid_values
Useful queries:
1. select * from v$nls_valid_values where parameter='LANGUAGE';
2. select * from v$nls_valid_values where parameter='SORT';
3. select * from v$nls_valid_values where parameter='TERRITORY';
4. show parameter nls_language
5. show parameter nls_date_language
6. show parameter nls_sort

No comments: