|
|
| Re: Default set setting.... [message #242800 is a reply to message #242798] |
Tue, 05 June 2007 02:59  |
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
|
Senior Member |
|
|
dwadm@DW.US.ORACLE.COM> SHOW LINESIZE
linesize 80
dwadm@DW.US.ORACLE.COM> SHOW PAGESIZE
pagesize 14
dwadm@DW.US.ORACLE.COM>
Defaults
| Quote: | * SET COLSEP - The separator characters between columns (default is a space)
* SET ECHO - Determines if SQL*Plus commands should be echoed or not. The default is OFF meaning SQL*Plus commands will not be echoed.
* SET HEADING - Determines if column headings should be displayed or not. Default is ON.
* SET LINESIZE - Determines the maximum number of characters in a line of output. The default is 80.
* SET LONG - Determines how much data in a LONG column will be displayed. The default is 80 bytes.
* SET NULL - Determines what value should be displayed in place of a NULL value.
* SET PAGESIZE - The number of lines for one page (before the headers repeat). The default is 24 lines.
* SET PAUSE - Determines if output should be paused after PAGESIZE lines have been displayed. The default is OFF.
* SET TRIMOUT - Determines if each line should be padded with blanks out to a length of LINESIZE. The default is ON meaning the output will be trimmed (e.g., will not be padded with spaces).
* SET WRAP - Determines if the output will be wrapped to the next line or truncated if the line is longer than LINESIZE. The default is ON meaning long output will be wrapped.
|
[Updated on: Tue, 05 June 2007 03:00] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
