number(x)
number(x, y)
SQL> col parameter format a50
SQL> col value format a60
SQL> 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
PARAMETER VALUE
-------------------------------------------------- ------------------------------------------------------------
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
17 개의 행이 선택되었습니다.
CLOB
BLOB