Commands supported by pl SQL developer command window

 

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 abve 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 shoshould be scanned
Set serverout [put] [ON | off] [size N]	Determines if output of callto 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 [small]	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