Showing posts with label Oracle Globalization. Show all posts
Showing posts with label Oracle Globalization. Show all posts

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