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