How to Check Character Set in Oracle

SQL> select * from nls_database_parameters where parameter like '%SET%';

PARAMETER                                  VALUE
------------------------------ ----------------------------------------
NLS_CHARACTERSET               AR8ISO8859P6
NLS_NCHAR_CHARACTERSET         AL16UTF16




Happy Learning...

How to Connect Oracle Database Directly on Windows Server

If there is only one database in your windows server, and you want to connect directly from the

server without setting the parameter every time...

Pls check this link...

http://www.orafaq.com/node/2977