Jasinski Technical Wiki

Navigation

	Home Page
	Index
	All Pages

Quick Search

Advanced Search »

Contributor Links

	Create a new Page
	Administration
	File Management
	Login/Logout
	Your Profile

Other Wiki Sections

PoweredBy

Discuss (0) History

SQL*Plus Commands Quick Reference - Oracle

Print

RSS

Modified on Fri, Jan 09, 2009, 12:34 PM by Administrator Categorized as Oracle, Quick Reference

Command	Alias	Usage
`APPEND text`	`A`	Adds text to the end of the current line
`CHANGE/old/new`	`C`	Changes occurences of old text to new text in the current line. If only old is present, its occurences are deleted from the current line.
`CLEAR BUFFER`	`CL BUFF`	Deletes all lines from the SQL buffer
`DEL m n`		Deletes the current line (`m`? `n`?)
`INPUT text`	`I`	Inserts an indefinite number of lines. If `text` is present, inserts a line consisting of `text`.
`LIST m n`	`L`	Lists all lines in the SQL buffer, or `m` lines (if present), or lines `m` to `n` (if both present).
`RUN`	`R`	Displays then runs the current SQL statement in the buffer
`n text`		Specifies the line to make the current line. If text is present, the text of line `n` is replaced with `text`.
`0 text`		Inserts a line before line 1, using `text`
`SAVE filename {REPLACE\|APPEND}`	`SAV`	Saves the current contents of the buffer to a file, with a default exension of SQL. `APPEND` adds the text to an existing file; `REPLACE` overwrites an existing file.
`GET filename`		Writes the contents of a file to the SQL buffer, with a default extension of SQL, retrieving only the SQL statements, not the SQL*Plus statements.
`START filename`	`STA`	Runs a previously saved command file, with a default extension of SQL.
`@filename`		Same as `START`
`EDIT filename`	`ED`	Invokes editor to edit the contents of a file, with a default extension of SQL.
`SPOOL filename OFF\|OUT`	`SPO`	Stores query results in a file. `OFF` closes the spool file; `OUT` closes the spool file and sends the file results to a system printer.
`EXIT`		Leaves SQL*Plus

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.