Home » SQL & PL/SQL » SQL & PL/SQL » SET COMMANDS
SET COMMANDS [message #214544] Tue, 16 January 2007 23:36 Go to next message
ramyashree.rp
Messages: 9
Registered: January 2007
Junior Member
Hi all,
can anybody give me some information about all the set commands in sql plus with examples
Re: SET COMMANDS [message #214546 is a reply to message #214544] Tue, 16 January 2007 23:58 Go to previous messageGo to next message
hari.choprala
Messages: 65
Registered: November 2006
Location: Mumbai
Member

Hi

You can get information in this link

http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96540/queries5a.htm#2054266


rgds
Hari Krishna
Re: SET COMMANDS [message #214549 is a reply to message #214546] Wed, 17 January 2007 00:06 Go to previous messageGo to next message
hari.choprala
Messages: 65
Registered: November 2006
Location: Mumbai
Member

Hi

Sorry for my earlier post. I thought You are asking for set operators.

You can use SET to control SQL*Plus environment settings for the current session. For example: the display width for data, number of lines per page or enable/disable printing of column heading. There are many variables that you can set. Some are shown here. The rest can be found directly on HELP SET in the SQL*Plus.



SYNTAX:


SET system_variable value

Where: some of these system_variables and values are


AUTO[COMMIT] {OFF|ON|IMM[EDIATE]|n} : controls when Oracle commits pending changes to the database. .

ECHO {OFF|ON} : sets whether START lists each command in a command file as the command is executed. ON lists the commands; OFF does not.

FEED[BACK] {6|n|OFF|ON} : shows the number of records returned by a query when at n or more records are selected. ON sets n to 1. Zero is the same as OFF.

HEA[DING] {OFF|ON} : controls printing of column headings in reports. ON prints column headings in reports; OFF suppresses column headings.

PAGES[IZE] {24|n} : sets the number of lines in each page. Set PAGESIZE to zero to suppress headings, page breaks, titles, the initial blank line, and other formatting information.

PAU[SE] {OFF|ON|text} : controls scrolling on the terminal when running reports. .

TERM[OUT] {OFF|ON} : controls the display of output generated by commands executed from a command file. .

TI[ME] {OFF|ON} : controls the display of the current time. ON displays the current time before each command prompt. OFF suppresses the time display.

TIMI[NG] {OFF|ON} : sets the display of timing statistics. Use the TIMING command to control the timing of multiple commands.


I think this is ok for You.

rgds

Hari Krishna

Re: SET COMMANDS [message #214552 is a reply to message #214549] Wed, 17 January 2007 00:20 Go to previous messageGo to next message
ramyashree.rp
Messages: 9
Registered: January 2007
Junior Member
thanks for the info. but i need some examples for these to undestand. i am searching in the net, i am getting the explanation for this but not able to undesrsatnd in a practically. some of them i understood. there r many set commands in sql plus.

SET APPI[NFO]{ON|OFF|text}
SET ARRAY[SIZE] {15|n}
SET BLO[CKTERMINATOR] {.|c}
SET CMDS[EP] {;|c|ON|OFF}
SET COM[PATIBILITY] {V7|V8|NATIVE}
SET CON[CAT] {.|c|ON|OFF}
SET COPYTYPECHECK {ON|OFF}
SET EMB[EDDED] {ON|OFF}
SET FLAGGER {OFF|ENTRY|INTERMED[IATE]|FULL}
SET FLU[SH] {ON|OFF}
SET HEADS[EP] {||c|ON|OFF}
SET AUTO[COMMIT] {ON|OFF|IMM[EDIATE]|n}
SET AUTOP[RINT] {ON|OFF}
SET AUTORECOVERY {ON|OFF]
SET AUTOT[RACE] {ON|OFF|TRACE[ONLY]} [EXP[LAIN]] [STAT[ISTICS]]
SET COLSEP {_|text}
SET COPYC[OMMIT] {0|n}
SET DEF[INE] {’&’|c|ON|OFF}
SET DESCRIBE [DEPTH {1|n|ALL}][LINENUM {ON|OFF}][INDENT {ON|OFF}]
SET ECHO {ON|OFF}
SET EDITF[ILE] file_name[.ext]
SET ESC[APE] {\|c|ON|OFF}
SET FEED[BACK] {6|n|ON|OFF}
SET HEA[DING] {ON|OFF}
SET INSTANCE [instance_path|LOCAL]
SET LIN[ESIZE] {80|n} (default is 150 in iSQL*Plus)
SET LOBOF[FSET] {n|1}
SET LOGSOURCE [pathname]
SET LONG {80|n}
SET LONGC[HUNKSIZE] {80|n}
SET MARK[UP] HTML [ON|OFF] [HEAD text] [BODY text] [TABLE text]
[ENTMAP {ON|OFF}] [SPOOL {ON|OFF}] [PRE[FORMAT] {ON|OFF}]
SET NEWP[AGE] {1|n|NONE}
SET NULL text
SET NUMF[ORMAT] format
SET NUM[WIDTH] {10|n}
SET PAGES[IZE] {24|n}
SET PAU[SE] {ON|OFF|text}
SET RECSEP {WR[APPED]|EA[CH]|OFF}
SET RECSEPCHAR {_|c}
SET SERVEROUT[PUT] {ON|OFF} [SIZE n] [FOR[MAT] {WRA[PPED]
|WOR[D_WRAPPED]|TRU[NCATED]}]
SET SHIFT[INOUT] {VIS[IBLE]|INV[ISIBLE]}
SET SHOW[MODE] {ON|OFF}
SET SQLBL[ANKLINES] {ON|OFF}
SET SQLC[ASE] {MIX[ED]|LO[WER]|UP[PER]}
SET SQLCO[NTINUE] {> |text}
SET SQLN[UMBER] {ON|OFF}
SET SQLPLUSCOMPAT[IBILITY] {x.y[.z]}
SET SQLPRE[FIX] {#|c}
SET SQLP[ROMPT] {SQL>|text}
SET SQLT[ERMINATOR] {;|c|ON|OFF}
SET SUF[FIX] {SQL|text}
SET TAB {ON|OFF}
SET TERM[OUT] {ON|OFF}
SET TI[ME] {ON|OFF}
SET TIMI[NG] {ON|OFF}
SET TRIM[OUT] {ON|OFF}
SET TRIMS[POOL] {ON|OFF}
SET UND[ERLINE] {-|c|ON|OFF}
SET VER[IFY] {ON|OFF}
SET WRA[P] {ON|OFF}
Re: SET COMMANDS [message #214553 is a reply to message #214552] Wed, 17 January 2007 00:28 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Where did you get this list? Did this source not also provide an explanation of them?
Re: SET COMMANDS [message #214623 is a reply to message #214552] Wed, 17 January 2007 05:29 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Have you tried SQL*Plus User's Guide. It provides explanation and examples of most of these commands.
Re: SET COMMANDS [message #214753 is a reply to message #214623] Wed, 17 January 2007 22:39 Go to previous messageGo to next message
ramyashree.rp
Messages: 9
Registered: January 2007
Junior Member
I got these from the net itself. i got examples for many from which i could able to understand most of the commands.
But i need some help in abt these commands.

SET APPI[NFO]{ON|OFF|text}
SET ARRAY[SIZE] {15|n}
SET BLO[CKTERMINATOR] {.|c}
SET CMDS[EP] {;|c|ON|OFF}
SET COM[PATIBILITY] {V7|V8|NATIVE}
SET CON[CAT] {.|c|ON|OFF}
SET COPYTYPECHECK {ON|OFF}
SET EMB[EDDED] {ON|OFF}
SET FLAGGER {OFF|ENTRY|INTERMED[IATE]|FULL}
SET FLU[SH] {ON|OFF}
SET HEADS[EP] {||c|ON|OFF}
SET INSTANCE [instance_path|LOCAL]
Re: SET COMMANDS [message #214761 is a reply to message #214753] Wed, 17 January 2007 23:20 Go to previous message
hari.choprala
Messages: 65
Registered: November 2006
Location: Mumbai
Member

Hi

go thru the below link

http://www.ss64.com/orasyntax/plus_set.html

rgds
Hari Krishna
Previous Topic: PL-SQL Trigger ..... Help needed
Next Topic: how to check data type and length
Goto Forum:
  


Current Time: Sun Dec 11 00:26:23 CST 2016

Total time taken to generate the page: 0.09875 seconds