SQLPlus 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