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. |