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