Detailed commands for setting the display format of Oracle sqlplus

Command
Description

/
Run SQL Buffer

? [Keywords]
SQL help for keywords

@ [@] [File name] [parameter list]
Run the specified command file with the specified parameter

ACC [EPT] variable [DEF [AULT] value] [PROMPT text | NOPR [OMPT]
Allow users to enter replacement variable values

CL [EAR] [SCR [EEN]
Clear Screen

CL [EAR] SQL
Clear SQL Buffer

COL [UMN] [column] [format] [NEW_VALUE variable]
Define the format of a column, display the format of a column, or display all column formats

CON [NECT] [user name/password @ database]
With the specified user connected to the database

DEF [INE] [variable] [= text]
Define a replacement variable, display a variable, or display all replacement variables.

DESC [RIBE] Object
A description for the specified object

DISC [CONNECT]
Disconnect from database

EDIT
Show text editor to edit SQL Buffer

EXEC [UTE] Process
Run the specified process

EXIT [APPLICATION]
Exit the running script or close the command window. Adding the APPLICATION parameter will also disable PL/SQL Developer.

GET [file name]
Load the command file to the editor

HOST [command]
Run host commands

HELP [Keywords]
SQL help for keywords

PAUSE [information]
Display Information and pause until you press OK or cancel

PRI [NT] [variable]
Display the bound variable or all bound variable values

PROMPT [text]
Display specified text

QUIT [APPLICATION]
Exit the running script or close the command window. Adding the APPLICATION parameter will also disable PL/SQL Developer.

R [UN]
Run SQL Buffer

REM [ARK] [text]
One comment line

Set autop [RINT] [ON | OFF]
Determine whether the bound variable is automatically displayed after running an SQL statement or PL/SQL block.

Set colsep [delimiter | OFF]
The column separator is determined (default = "").

Set con [CAT] [character | ON | OFF]
Determines the character used to terminate the replacement variable (default = .)

Set def [INE] [character | ON | OFF]
Determine the character used to replace the variable reference (default = &)

Set echo [ON | OFF]
Check whether the commands executed in the script are displayed.

Set esc [APE] [character | ON | OFF]
Determine the characters starting to replace the variable's reference characters (default = \)

Set feed [BACK] [ON | OFF]
Determine whether the number of affected SQL statements is displayed

Set hea [DING] [ON | OFF]
Determine whether the title in the result set column is displayed

Set long [width]
Determines the maximum display width of a LONG column.

Set num [WIDTH] [WIDTH]
Determines the maximum display width of numeric columns without precision

Set pages [IZE] [size]
Determine the number of rows displayed in the result set before the title is repeated

Set prompt [PROMPT]
Replace the standard SQL> prompt. You can also use text of the variable [user], [db], or [connection. In addition, you can include a Bind Variable (set prompt: bind_var_name ).

Set scan [ON | OFF]
Determine whether the replacement variable should be scanned

Set serverout [PUT] [ON | OFF] [SIZE n]
Determine whether the output of dbms_output.put_line is displayed and the size of the output buffer.

Set spool * DIRECTORY [DIRECTORY]
Determine the directory in which the offline files are stored if the SPOOL command does not specify an absolute path.

Set term [OUT] [ON | OFF]
Check whether the output of running SQL statements is displayed.

Set timi [NG] [ON | OFF]
Check whether the timing information of running SQL statements is displayed.

Set ver [IFY] [ON | OFF]
Determine whether the replacement variable is displayed when it is used in SQL statements or PL/SQL blocks.

SHO [W] ERR [ORS] [type name]
Displays errors of previously compiled or specified objects

SHO [W] REL [small]
Displays the Oracle version of the current connection.

SHO [W] SQLCODE
Displays the result code of a running SQL statement.

SHO [W] USER
Display the User Name of the current connection

SPO [OL] [file name | OFF]
Start or stop a fake offline job

STA [RT] [file name] [parameter list]
Run the specified command file with the specified parameter

Store set [file name]
Store the values of all options in the [file name]. You can run this file later to restore these options.

UNDEF [INE] variable
Do not define preset replacement Variables

VAR [IABLE] [variable] [data type]
Define a binding variable to display a binding variable or all binding variables.

WHENEVER [OSERROR | SQLERROR] [action]
Specifies an action, regardless of when an error occurs in the OS or SQL statement. This action can be both EXIT and CONTINUE, and is followed by COMMIT or ROLLBACK.

All the preceding command functions are the same as SQL * Plus. The following command is unique to PL/SQL Developer:

Command
Description

BEAUT [IFY] File | object
Use the rules specified by the current rule or the set beautifierrules command to beautify the specified file or database object.

BROWSE object
Select an object in the Object Browser

EDIT object
Open an editable window with an object definition

EDITD [ATA] Table | View
Open an SQL window for tables or views with editable result sets

EXPORT [DATA] Table
Open an export tool for a specified table

INFO
Display connection information

PROP [ERTIES] Object
Display an attribute window for a specified object

QUERY [DATA] Table | View
Open an SQL window for a table or view with a read-only result set

REC [OMPILE] Object
Recompile the object

Set beaut [IFIERRULES] [file]
Temporarily use the beautification rule from the specified file, which can be used with the BEAUTIFY command.

Set col [WIDTH] [WIDTH]
Determine the maximum column width in the result set. If Width = 0, the Width is not limited. The default value is 80.

Set exec [PAUSE] [ON | OFF]
Pause the next command or stop the next command ).

SQLPLUS
Call SQL * Plus with the current file.

TEST Program unit
For the specified program unit, open a test window with a standard test script.

VIEW object
Open a read-only window with an object definition