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