what is the difference between the following two commands to find the characterset


what is the difference between the following two commands to find the characterset

1.select * from v$nls_parameters;

2. select value from nls_database_parameters where parameter='NLS_CHARACTERSET';

Please advise. Any links, resources, ideas, sample code highly appreciated. Thanks in advance.
LVL 7
gudii9Asked:
Who is Participating?
 
Tapan PattanaikSenior EngineerCommented:

Q 1. this command is used for
 

SQL> SELECT * FROM V$NLS_PARAMETERS;
or
SQL> select * from nls_database_parameters;

ans. How to check current database character set?

Q2.  
select value from nls_database_parameters where parameter = 'NLS_CHARACTERSET';

ans. The (ordinary) character set for a database can be determined.
0
 
Tapan PattanaikSenior EngineerCommented:

 Hi gudii9,

 The (ordinary) character set for a database can be determined with:

select value from nls_database_parameters where parameter = 'NLS_CHARACTERSET';
0
 
gudii9Author Commented:
thank you very much
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.