The commands shown in Table A-1 are SQL*Plus commands available in the command-line interface. Not all commands or command parameters are shown. See Also: SQL*Plus Quick Reference SQL*Plus User's Guide and Reference Table A-1 Basic SQL*Plus Commands Database OperationSQL*Plus Command ...
This appendix covers earlier versions of some SQL*Plus commands. While these older commands still function within SQL*Plus, they are no longer supported. It is recommended that you use the alternative SQL*Plus commands listed in the following table....
Below table shows, SQL*Plus commands available in the command-line interface. Not all commands or command parameters are shown.How to … SQL*Plus Command Log in to SQL*Plus SQLPLUS [ { username[/passward][@connect_identifier] | / } [ AS { SYSDBA | SYSOPER } ] | /NOLOG ] List help...
terminates SQL * Plus and returns control to the operating system. In iSQL * Plus, commits or rolls back all pending changes, stops processing the current iSQL * Plus script and returns focus to the Workspace. There is no way to access the return code in iSQL * Plus. In iSQL * Plus...
slash (/)inthe iSQL*Plus Workspace. The buffer has no command historyanddoesnotrecord SQL*Plus commands. 例子:如下图所示: ---5 ACCEPT SQL>HELP ACCEPT ACCEPT可以修改既有变量,也可定义一个新变量并等待用户输入初始值。 ACCEPT --- Reads
The SQL Worksheet currently supports a number of SQL*Plus commands. SQL*Plus commands which are not supported by the SQL Worksheet are ignored and are not sent to the Oracle database. CommandRelease 1.1Release 1.2.1Release 1.5Release 1.5.5Release 2.1Release 3.0 @ Yes Yes Yes Yes Yes Yes @...
Display commands as they are executed FLU[SH] {OFF|ON} Buffer display output (OS) (no longer used in Oracle 9) Please see bellow for more detailhttp://ss64.com/ora/syntax-sqlplus-set.html SQL*PLUS - SET Statement Set sqlplus system settings and defaults. ...
Supported SQL*Plus Commands @file_name[.ext] [arg ...] Runs SQL*Plus statements in the specified script. @@file_name[.ext] [arg ...] Runs a script. This command is similar to the @ (at sign) command. It is useful for running nested scripts because it looks for the specified scri...
-- SQL*Plus global login "site profile" file -- -- Add any SQL*Plus commands here that are to be executed when a -- user starts SQL*Plus, or uses the SQL*Plus CONNECT command. set linesize 300 ; set pagesize 100 ; 1. 2. ...
SQL>REM It contains the SQL*Plus commands to create a custom SQL>REM SQL Profile for SQL_ID 9bf751pc4r9c9 based on plan hash SQL>REM value 1494048713. SQL>REM The custom SQL Profile to be created by this script SQL>REM will affect plans for SQL commands with signature ...