728x90
SQL> select * from t;
MY_COLUMN
----------
1234567890
1.2346E+12
1.2346E+19
SQL> set numformat 999999999999999999999999999999999999999.999999999999999999
문자열 개시 "9999999999..." 너무 깁니다. 최대 크기는 49 문자입니다.
SQL> set numformat 9999999999999999999999999999999.999999999999999999
문자열 개시 "9999999999..." 너무 깁니다. 최대 크기는 49 문자입니다.
SQL> set numformat 999999999999999999999999.9999999999
SQL> set numformat 999999999999999999999999.9999999999
SQL> select * from t;
MY_COLUMN
------------------------------------
1234567890.0000000000
1234567890123.0000000000
12345678902354234123.0000000000
SQL> set numformat "" << 원래대로~
SQL> /
MY_COLUMN
----------
1234567890
1.2346E+12
1.2346E+19
728x90