How do you find the codeset that is being used?

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: How do you find the codeset that is being used?


Solution:


Run the following script to check which codeset is being used:
SELECT tag FROM fnd_lookup_values
WHERE lookup_type = 'FND_ISO_CHARACTER_SET_MAP' AND
lookup_code = SUBSTR(USERENV('LANGUAGE'), INSTR(USERENV('LANGUAGE'), '.')+1) AND language = 'US';

Get Oracle Certifications for all Exams
Free Online Exams.com