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' ) ;
'TIBERO > DBA' 카테고리의 다른 글
JDBC-21004:No more extent available in tablespace '테이블스페이스명'. (1) | 2024.05.22 |
---|---|
DB (테이블스페이스) 용량 확인 (1) | 2024.05.22 |
티베로 DBLINK 생성방법 (0) | 2024.05.10 |
TIBERO STUDIO EXPORT 2% 부족한점 (0) | 2024.05.08 |
TIBERO INDEX JOIN (0) | 2024.04.19 |