Supported commands
Besides all SQL statements, the command window supports the following standard SQL*PLus commands in this release:
Command | Meaning |
/ | Executes the SQL buffer |
? [Keyword] | Provides SQL help on the keyword |
@[@] [Filename] [Parameter list] | Runs the specified command file, passing the specified parameters |
ACC[EPT] Variable [DEF[AULT] Value] [PROMPT Text | NOPR[OMPT]] | Allows the user to enter the value of a substitution variable |
CL[EAR] [SCR[EEN]] | Clears the screen |
CL[EAR] SQL | Clears the SQL buffer |
COL[UMN] [Column] [Format] [NEW_VALUE Variable] | Defines the format of a column, displays the format of a column, or displays all column formats |
CON[NECT] [username/password@database] | Connects to the database with the speciffied user |
DEF[INE] [Variable] [ = Text] | Defines a substitution variable, displays a variable, or displays all substitution variables. |
DESC[RIBE] Object | Gives a description of the specified object |
DISC[CONNECT] | Disconnects from the database |
EDIT | Displays a text editor to edit the SQL buffer |
EXEC[UTE] Procedure | Executes the specified procedure |
EXIT [APPLICATION] | Quits a running script or closes the Command Window. Adding the APPLICATION parameter will also close PL/SQL Developer. |
GET [Filename] | Loads a command file into the editor |
HOST [Command] | Executes the host command |
HELP [Keyword] | Provides SQL help on the keyword |
PAUSE [Message] | Displays the message and pauses until the user presses Okay or Cancel |
PRI[NT] [Variable] | Displays the value of the bind variable, or all bind variables |
PROMPT [Text] | Displays the specified text |
QUIT [APPLICATION] | Quits a running script or closes the Command Window. Adding the APPLICATION parameter will also close PL/SQL Developer. |
R[UN] | Executes the SQL buffer |
REM[ARK] [Text] | A comment line |
SET AUTOP[RINT] [ON | OFF] | Determines if bind variables are automatically displayed after executing a SQL statement or PL/SQL block. |
SET COLSEP [Separator | OFF] | Determines the column separator (default = “ ”). |
SET CON[CAT] [Character | ON | OFF] | Determines the character that terminates a substitution variable reference (default = .) |
SET DEF[INE] [Character | ON | OFF] | Determines the character that starts a substitution variable reference (default = &) |
SET ECHO [ON | OFF] | Determines if executed commands in a script are displayed |
SET ESC[APE] [Character | ON | OFF] | Determines the character that escapes the character that starts a substitution variable reference (default = \) |
SET FEED[BACK] [ON | OFF] | Determines if the number of affected rows of a SQL statement is displayed |
SET HEA[DING] [ON | OFF] | Determines if headings are displayed above the columns of a result set |
SET LONG [Width] | Determines the maximum display width of a long column |
SET NUM[WIDTH] [Width] | Determines the maximum display width of a number column without precision |
SET PAGES[IZE] [Size] | Determines the number of lines that are displayed for a result set, before the headings are repeated |
SET PROMPT [Prompt] | Replace the standard SQL> prompt. Instead of a literal text you can also use the variables [user], [db], or [connection]. Furthermore you can include a bind variable (set prompt :bind_var_name). |
SET SCAN [ON | OFF] | Determines if substitution variables should be scanned |
SET SERVEROUT[PUT] [ON | OFF] [SIZE n] | Determines if output of calls to dbms_output.put_line is displayed, and what the size of the output buffer is |
SET SPOOL*DIRECTORY [Directory] | Determines in which directory spool files are stored if the SPOOL command does not specify an absolute path. |
SET TERM[OUT] [ON | OFF] | Determines if output of executed SQL statements is displayed |
SET TIMI[NG] [ON | OFF] | Determines if timing information about executed SQL statements is displayed |
SET VER[IFY] [ON | OFF] | Determines if substitution variables are displayed when used in a SQL statement or PL/SQL block |
SHO[W] ERR[ORS] [Type Name] | Displays errors for the previous compilation, or for the specified object |
SHO[W] REL[EASE] | Displays Oracle release information for the current connection |
SHO[W] SQLCODE | Displays the result code of the executed SQL statement |
SHO[W] USER | Displays the username of the current connection |
SPO[OL] [Filename [APPEND]] | OFF | OUT] | Starts or stops spooling and optionally print (OUT) |
STA[RT] [Filename] [Parameter list] | Runs the specified command file, passing the specified parameters |
STORE SET [Filename] | Stores the values of all options in the filename. You can execute this file later to restore these options. |
UNDEF[INE] Variable | Undefines the given substitution variable |
VAR[IABLE] [Variable] [Datatype] | Defines a bind variable, displays a bind variable, or displays all bind variables. |
WHENEVER [OSERROR | SQLERROR] [Action] | Specify an action whenever an OS error or SQL error occurs. The action can either be EXIT or CONTINUE, optionally followed by COMMIT or ROLLBACK. |
All of these commands function the same as in SQL*Plus. The following commands are specific to PL/SQL Developer:
Command | Meaning |
BEAUT[IFY] File | Object | Beautifies the specified file or database object, using the current rules or the rules specified with the SET BEAUTIFIERRULES command. |
BROWSE Object | Select the Object in the Object Browser |
EDIT Object | Opens an editable window with the object’s definition |
EDITD[ATA] Table | View | Opens a SQL Window for the table or view with an editable result set |
EXPORT[DATA] Table | Opens the Export Tool for the specified table |
INFO | Displays information about the connection |
PROP[ERTIES] Object | Displays a Property Window for the specified object |
QUERY[DATA] Table | View | Opens a SQL Window for the table or view with a read-only result set |
REC[OMPILE] Object | Recompiles the object |
RUNTEST[SET] TestSetFile [LogFile] | Runs the specified Test Set File in the Test Manager and logs the result in the Log File. |
SET BEAUT[IFIERRULES] [File] | Temporarily use the beautifier rules from the specified file. This can be used with the BEAUTIFY command. |
SET COL[WIDTH] [Width] | Determines the maximum column width in a result set. If Width = 0, the width is unlimited. The default is 80. |
SET EXEC[PAUSE] [ON | OFF] | Pauses execution at the next command (ON), or continues normally with the next command (OFF). |
SQLPLUS | Invokes SQL*Plus with the current file. |
TEST ProgramUnit | Opens a Test Window with a standard Test Script for the specified program unit |
VIEW Object | Opens a read-only window with the object’s definition |