Friday, May 8, 2009

SQLPLUS edit and format tips


set long 500 longchunksize 500

list - print all rows
change - c /old/new
del - del 4 will delete 4th line
input - input order by 2 will append line as last line
APPEND - Adds specified text to the end of the current line in the buffer
#############Col and Report format################
ttitle - center 'Redo Log Summary' skip 2
col group# format 999 heading 'Group'
col member format a45 heading 'Member' justify c
col status format a10 heading 'Status' justify c
col archived format a10 heading 'Archived'
col fsize format 99 heading 'Size(MB)'

No comments: