In Oracle Database, it has 2 different character set, character set and National character set. The character set is used for all normal data types such as VARCHAR2. National character set is used for NVARCHAR2.
How to check the character set and national character set for the database.
- PROPS$
- V$NLS_PARAMETERS
- NLS_DATABASE_PARAMETERS
select * from PROPS$;
col parameter format a30
col value format a32
select * from V$NLS_PARAMETERS;
col parameter format a30
col value format a32
select * from NLS_DATABASE_PARAMETERS;
ERPTREE Offering Oracle fusion HCM online training, Oracle Fusion SCM Online Training, Oracle fusion financials online training, Oracle fusion hcm training, Oracle fusion scm training, Oracle fusion financials training, Oracle fusion dba online training in Hyderabad, Bangalore,Gurgon, Noida, India, Dubai, UAE, USA, Kuwait, UK, Singapore, Saudi Arabia, Canada, Delhi, Chennai, Kolkata, Pune, Mumbai, Ahmedabad.
ReplyDeleteOracle Fusion HCM Training
Great Article Artificial Intelligence Projects
DeleteProject Center in Chennai
JavaScript Training in Chennai
JavaScript Training in Chennai
Impetus provides sql certification training in PCMC pune. If anyone looking for sql classes in pune then please contact us today for sql certification in pune.
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteThank you for sharing such a nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information.
ReplyDeleteOracle Fusion Financials Online Training
I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.
ReplyDeleteoracle fusion financials training in hyderabad
I admire this article for well-researched content and excellent wording. Thank you for providing such a unique information here. Oracle Fusion Apps Training
ReplyDelete