ORACLE|NLS Parameters(Charset) / Version

--Oracle Version

SELECT * FROM V$VERSION;

--Oracle NLS Parameters

SELECT  * 

FROM    NLS_DATABASE_PARAMETERS;

SELECT * FROM NLS_SESSION_PARAMETERS --현재 로그인 세션의 NLS 셋팅값 조회.

--Oracle Charset 

SELECT * FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER LIKE '%CHARACTERSET%';

------------------------------------------------------------------------

PARAMETER VALUE

------------------------------------------------------------------------

NLS_LANGUAGE                        AMERICAN

NLS_TERRITORY                        AMERICA

NLS_CURRENCY                        $

NLS_ISO_CURRENCY                 AMERICA

NLS_NUMERIC_CHARACTERS .,

NLS_CHARACTERSET  KO16MSWIN949

NLS_CALENDAR         GREGORIAN

NLS_DATE_FORMAT DD-MON-RR

NLS_DATE_LANGUAGE AMERICAN

NLS_SORT         BINARY

NLS_TIME_FORMAT HH.MI.SSXFF AM

NLS_TIMESTAMP_FORMAT        DD-MON-RR HH.MI.SSXFF AM

NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR

NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR

NLS_DUAL_CURRENCY $

NLS_COMP BINARY

NLS_LENGTH_SEMANTICS         BYTE

NLS_NCHAR_CONV_EXCP FALSE

NLS_NCHAR_CHARACTERSET AL16UTF16

NLS_RDBMS_VERSION 9.2.0.1.0

------------------------------------------------------------------------