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