La racionalitat de Claude C. Hopkins en la teoria de Pere Prat Gaballí

The Command Window allows you to execute SQL scripts in a way that is very much similar to Oracle's SQL*Plus. To create a Command Window press the New button on the toolbar or select the New item in the File menu. A Command Window is created and you can type SQL and SQL*Plus commands like you are used to, without leaving PL/SQL Developer’s IDE:

7.1 Entering SQL statements and commands

Just like in SQL*Plus, you can type SQL statements across multiple lines, and end a statement with a semi-colon or slash. You can use the cursor left and right keys to edit the command line, and use the cursor up and down keys to recall previously entered lines

By entering the edit command, you can use a simple text editor to edit the entire input buffer. After editing the buffer, you can execute it by entering a slash on the command line. The editor has a history buffer with all previously executed commands, so that you can quickly execute a modified command.

The status line of the Command Window shows the status of the Echo, Termout, Feedback, Verify, Autoprint, Heading and Timing options. You can additionally double-click on such an option to change it between on and off.

7.2 Developing command files

To develop a command file with multiple SQL statements and commands, you often need to edit the file, run it, edit it again, run it again, and so on. To make this a comfortable process, the Command Window has a built-in editor with SQL, PL/SQL and SQL*Plus syntax highlighting:

Opening, Executing, and Saving a command file

To create a command file, switch to the Editor page and enter the commands. To execute the commands in the editor, simply press the Execute button on the toolbar, or press F8. The Command Window will switch back to the Dialog page and will execute all commands.

To edit an existing command file, press the Open button on the toolbar and select the Command File item. This will load the command file into the editor of a new Command Window. You can

alternatively right-click in the editor and select the Load item from the popup menu. To save a modified Command File, press the Save button on the toolbar.

Stepping through a command file

If you press the Pause Execution button on the status line before or during execution, you can single-step though the script in a controlled manner. The next command will be highlighted in the Editor, and will be executed when you press the Execute Next Command button on the status line. If you press the Pause Execution button again, execution will continue normally after the next step. You can force such a pause from within a script by using the SET EXECPAUSE command.

7.3 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

Command Meaning

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 | OFF] Starts or stops spooling

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

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