set line set pagesize ....... oracle 的SQL*Plus中选项-环境,里面全部都是
自己去看看PLSQL DEVELOPER的帮助文档吧,不要在这你这种方式收集了: Command-line parameters plsqldev.exe userid=scott/tiger@chicago or HKEY_CURRENT_USER\Software\Allround Automations\PL/SQL Developer\Logon Here you can add a Username, Password and Database.The last method has the advantage that it enables you to be automatically logged on after double clicking a PL/SQL Developer registered file. nologon The nologon parameter suppresses the logon dialog that is displayed when PL/SQL Developer is started. This parameter does not require any arguments: plsqldev.exe nologon oraclehome You can specify the name of the Oracle Home on the command line, thereby overriding the Primary Oracle Home (which is used by default) and the Oracle Home preference: plsqldev.exe oraclehome=ora817 Note that this is the name of the Oracle Home, as specified in the ORACLE_HOME_NAME key in the registry. This name is also used by the Oracle Home Selector. dontadjustpath
PL/SQL Developer will not temporarily modify the PATH for Oracle Net initialization: plsqldev.exe dontadjustpath nosplash The nosplash parameter suppresses the splash screen that is displayed when PL/SQL Developer is started. This parameter does not require any arguments: plsqldev.exe nosplash noplugins Specifying the noplugins parameter will prevent that any Plug-Ins are loaded: plsqldev.exe noplugins library
Specify the location of the style library for reports: plsqldev.exe library=p:\standard.lib 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] 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 Quits a running script or closes the Command Window 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 Quits a running script or closes the Command Window 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 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 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 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 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 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
set pagesize
.......
oracle 的SQL*Plus中选项-环境,里面全部都是
Command-line parameters plsqldev.exe userid=scott/tiger@chicago
or
HKEY_CURRENT_USER\Software\Allround Automations\PL/SQL Developer\Logon
Here you can add a Username, Password and Database.The last method has the advantage that it enables you to be automatically logged on after double clicking a PL/SQL Developer registered file. nologon
The nologon parameter suppresses the logon dialog that is displayed when PL/SQL Developer is started. This parameter does not require any arguments: plsqldev.exe nologon oraclehome
You can specify the name of the Oracle Home on the command line, thereby overriding the Primary Oracle Home (which is used by default) and the Oracle Home preference: plsqldev.exe oraclehome=ora817 Note that this is the name of the Oracle Home, as specified in the ORACLE_HOME_NAME key in the registry. This name is also used by the Oracle Home Selector. dontadjustpath
PL/SQL Developer will not temporarily modify the PATH for Oracle Net initialization: plsqldev.exe dontadjustpath nosplash The nosplash parameter suppresses the splash screen that is displayed when PL/SQL Developer is started. This parameter does not require any arguments: plsqldev.exe nosplash noplugins Specifying the noplugins parameter will prevent that any Plug-Ins are loaded: plsqldev.exe noplugins library
Specify the location of the style library for reports: plsqldev.exe library=p:\standard.lib 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] 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 Quits a running script or closes the Command Window
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 Quits a running script or closes the Command Window
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 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 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 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
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 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
add /**/
change /000/111/
run
其实PLSQL DEVELOPER里,command window命令和SQLPLUS里面的完全一样
show parameter 是最新版本才加入的.另外还有些独特的,如:
test 过程名;
viewdata 表名
editdata 表名
querydata 表名
browse 对象名
....................................