Commands supported by pl SQL developer command window

Source: Internet
Author: User
Tags sql error

 

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.