Guides (Oracle8p)

Personal Oracle 8: SQL*Plus

SQ-2

sql_win.gif (6083 bytes)

Notes:

Commands are used with the SQL prompt (SQL>)
If you do not specify a path name the files are saved in Orawin95\bin.

Buffer commands

Command	Abbrev	Purpose	.	Command	Abbrev	Purpose
APPEND text	A text	Add text to end of current line		INPUT	I	Append lines to buffer
CHANGE	C/oldtext/newtext	Changes oldtext to newtext		LIST	L or ;	List buffer
CHANGE	C/text/	Delete text from current line		LIST n	L n	List line number n
CLEAR BUFFER	CL BUFF	Empty buffer		LIST n m	L n m	Lists lines n thru m
DEL	.	Deletes current line		RUN	R or /	Run sql buffer

Working commands

Command	Abbrev	Purpose	.	Command	Abbrev	Purpose
DESCRIBE	DESC	Disp database object structures, eg tables		GET filename	.	Load filename into buffer
ED filename	.	Use default editor to edit a file		SAVE filename	.	Saves buffer to filename
EXIT or QUIT	.	Quit SQL*Plus		SPOOL filename and SPOOL OFF	.	Sends all output to a filename. (Default extension is .lst)
EXIT or QUIT	.	Quit SQL*Plus		START filename	@	Executes the commands in filename

ref: pg 77.
[Rev 30/04/99] 18/4/99 © 1999 V/2-Com (Verhaart), P O Box 8415, Havelock North, New Zealand.