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
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?
Labels:
Oracle Globalization
Subscribe to:
Posts (Atom)