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
Wednesday, May 14, 2008
What is territory support in Oracle 10g?
Labels:
Oracle Globalization
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment