Wednesday, February 21, 2018

Display big numbers in SQLPLUS


show num(width)
set num(width) 15

num(width) parameter (2-15)


SQL> show num
numwidth 10

SQL> l
  1  select
  2  current_scn
  3  from
  4* v$database
SQL> /

CURRENT_SCN
-----------
 1.6139E+10


SQL> set num 15
SQL> l
  1  select
  2  current_scn
  3  from
  4* v$database
SQL> /

    CURRENT_SCN
---------------
    16138638611

SQL>

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

ALCATEL 6900

write memory copy running certified reload from working no rollback-timeout