Thursday, 28 April 2011

SET COMMANDS

ECHO {OFF|ON}
   Display commands as they are executed

HEA[DING] {OFF|ON}
   print column headings

LIN[ESIZE] {150|n}
   Width of a line (before wrapping to the next line)
   Earlier versions default to 80, Oracle 9 is 150

LONG {80|n}
   Set the maximum width (in chars) for displaying and copying LONG values.

PAGES[IZE] {14|n}
   The height of the page - number of lines.
   0 will suppress all headings, page breaks, titles

set timing on;
set time off;

No comments:

Post a Comment