<<Previous Next>>
Oracle -
Explain how to change SQL*Plus system settings - April 10, 2009
at 11:00 AM
Explain how to change SQL*Plus system
settings.
The SET command can be used to change the settings in the
SQl*PLUS environment.
SET AUTOCOMMIT OFF: Turns off the auto-commit feature
SET
FEEDBACK OFF: Stops displaying the "27 rows selected." message at
the end of the query output
SET HEADING OFF: Stops displaying the
header line of the query output
SET LINESIZE 256: Sets the number
of characters per line when displaying the query output
SET
NEWPAGE 2: Sets 2 blank lines to be displayed on each page of the
query output
SET NEWPAGE NONE: Sets for no blank lines to be
displayed on each page of the query output
SET NULL 'null': Asks
SQL*Plus to display 'null' for columns that have null values in the
query output
SET PAGESIZE 60: Sets the number of lines per page
when displaying the query output
SET TIMING ON: Asks SQL*Plus to
display the command execution timing data
SET WRAP OFF: Turns off the wrapping
feature when displaying query output.
Also read
SQL*Plus is an interactive and batch query tool, it gets
installed with every Oracle Database Server or Client
installation.............
The spooling feature facilitates copying of all the contents of
the command line SQL*Plus to a specified file. This feature is
called Spooling............
Input buffer feature of the command-line SQL*Plus tool allows a
revision of multiple-line command and rerunning it with a couple of
simple commands. The last SQL statement is...........
When a query needs to be run which has a condition that needs to
be a result of another query then, the query in the condition part of
the main one is called a sub-query................
|
