ORACLE과 TIBERO 6, 7 CHARACTER SET 확인

 

ORACLE

SELECT * FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME IN ( 
'NLS_TERRITORY'
,'NLS_LANGUAGE'
,'NLS_CHARACTERSET'
,'NLS_NCHAR_CHARACTERSET'
);

또는 

SELECT * FROM NLS_DATABASE_PARAMETERS
 WHERE PARAMETER IN ( 
'NLS_TERRITORY'
,'NLS_LANGUAGE'
,'NLS_CHARACTERSET'
,'NLS_NCHAR_CHARACTERSET'
);

 

TIBERO 6

SELECT NAME, VALUE FROM DATABASE_PROPERTIES 
WHERE NAME IN ( 
 'NLS_CHARACTERSET'
,'NLS_NCHAR_CHARACTERSET'
)

UNION ALL 

SELECT PARAMETER, VALUE 
  FROM NLS_DATABASE_PARAMETERS
WHERE PARAMETER IN ( 
 'NLS_TERRITORY'
,'NLS_LANGUAGE'
);

 

TIBERO 7

SELECT  A.*
  FROM V$NLS_PARAMETERS a 
 WHERE REGEXP_LIKE(PARAMETER,'CHARACTERSET|NLS_NCHAR_CHARACTERSET|NLS_TERRITORY|NLS_LANGUAGE','i' ) ;