Wednesday, December 5, 2012

5 Character set and National Character Set

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$;

image

col parameter format a30
col value format a32
select * from V$NLS_PARAMETERS;

image

col parameter format a30
col value format a32
select * from NLS_DATABASE_PARAMETERS;

image

Reference

5 comments:

  1. 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.


    Oracle Fusion HCM Training

    ReplyDelete
  2. 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.

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete
  4. Thank 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.

    Oracle Fusion Financials Online Training

    ReplyDelete
  5. 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.

    oracle fusion financials training in hyderabad

    ReplyDelete

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates