■ NLS_SESSION_PARAMETERS 뷰를 사용해 NLS 매개 변수 설정 값을 조회하는 방법을 보여준다.
▶ 예제 코드 (SQL)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
SELECT * FROM NLS_SESSION_PARAMETERS; /* PARAMETER VALUE ----------------------- -------------------------- NLS_LANGUAGE KOREAN NLS_TERRITORY KOREA NLS_CURRENCY ₩ NLS_ISO_CURRENCY KOREA NLS_NUMERIC_CHARACTERS ., NLS_CALENDAR GREGORIAN NLS_DATE_FORMAT RR/MM/DD NLS_DATE_LANGUAGE KOREAN NLS_SORT BINARY NLS_TIME_FORMAT HH24:MI:SSXFF NLS_TIMESTAMP_FORMAT RR/MM/DD HH24:MI:SSXFF NLS_TIME_TZ_FORMAT HH24:MI:SSXFF TZR NLS_TIMESTAMP_TZ_FORMAT RR/MM/DD HH24:MI:SSXFF TZR NLS_DUAL_CURRENCY ₩ NLS_COMP BINARY NLS_LENGTH_SEMANTICS BYTE NLS_NCHAR_CONV_EXCP FALSE */ |