SQL Plus Tutorial

SQL * Plus commands

The most important commands available in SQL * Plus are:

ACCEPT - used to read a variable input
DEF (DEFINE) - allow you to declare a variable
DESC (DESCRIBE) - lists the attributes of objects
EDIT - opens an editor
EXIT or QUIT - disconnects the user and SQL * Plus session
GET - searches for a file in SQL
HOST - running an operating system command
LIST - shows the last command executed
PROMPT - displays a text
RUN - lists and runs the command (/)
SAVE - save buffer command into a SQL script file
SET - change environment variables specific to SQL * Plus
SHOW - displays the environment variables settings in SQL * Plus
SPOOL - copies the output of a command to a file
START - run a SQL script



PL SQL Tutorial
Oracle Tutorial