Log in
updated 11:29 AM UTC, May 4, 2016

Change column width of show parameter in SQL Plus

  • Written by Manjunatha Srinivas
  • Published in Database
column NAME_COL_PLUS_SHOW_PARAM format a30
column VALUE_COL_PLUS_SHOW_PARAM format a30 
 
SQL> show parameter memory

NAME_COL_PLUS_SHOW_PARAM       TYPE        VALUE_COL_PLUS_SHOW_PARAM
------------------------------ ----------- ------------------------------
hi_shared_memory_address       integer     0
memory_max_target              big integer 5G
memory_target                  big integer 5G
shared_memory_address          integer     0

Powered by Bullraider.com
Follow Us on Twitter
Find Us on Facebook
Follow Us on Google
Follow Us on Pinterest