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>
Subscribe to:
Post Comments (Atom)
ALCATEL 6900
write memory copy running certified reload from working no rollback-timeout
-
SET LLDP System NAME: system name ALL-Uplink system location SIAM-FL11 SHOW LLDP Configure: show lldp config or show lldp local-syste...
-
grant execute on utl_http to wc grant execute on dbms_lock to wc; BEGIN DBMS_NETWORK_ACL_ADMIN.create_acl ( acl => ...
-
:system view system-view or sys :show all config dis current-configuration :create vlan vlan vlan_number :show ip interface ...
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.