Wednesday, December 5, 2012

1 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

1 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

 

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