Home » SQL & PL/SQL » Client Tools » Default set setting....
Default set setting.... [message #242798] Tue, 05 June 2007 02:50 Go to next message
Messages: 36
Registered: May 2007
Hi all,

i want to know what are the default values for all these set commands:

1. set linesize
2. set pagesize

Re: Default set setting.... [message #242800 is a reply to message #242798] Tue, 05 June 2007 02:59 Go to previous message
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

linesize 80
pagesize 14

* 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

Previous Topic: set command
Next Topic: date display in report
Goto Forum:

Current Time: Fri May 07 04:39:14 CDT 2021