SqlPlusStatementType Enumeration

In This Topic

Describes type of SQL*Plus command. Unless the corresponding SQL*Plus command name is explicitly specified, it coincides with the enumeration member's title. The functionality of corresponding commands in SQL*Plus is given below.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum SqlPlusStatementType 
   Inherits System.Enum
   Implements System.IComparable, System.IConvertible, System.IFormattable

public enum SqlPlusStatementType : System.Enum, System.IComparable, System.IConvertible, System.IFormattable

Members

Member	Description
Accept	Represents the ACCEPT SQLPlus command. In SQLPlus this command reads a line of input and stores it in a given user variable.
Append	Represents the APPEND SQLPlus command. In SQLPlus this command adds specified text to the end of the current line in the buffer.
Archive	Represents the ARCHIVE SQLPlus command. In SQLPlus this command starts or stops the automatic archiving of online redo log files, manually (explicitly) archives specified redo log files, or displays information about redo log files.
Attribute	Represents the ATTRIBUTE SQLPlus command. In SQLPlus this command specifies display characteristics for a given attribute of an Object Type column, and lists the current display characteristics for a single attribute or all attributes.
Break	Represents the BREAK SQLPlus command. In SQLPlus this command specifies where and how formatting will change in a report, or lists the current break definition.
Btitle	Represents the BTITLE SQLPlus command. In SQLPlus this command places and formats a specified title at the bottom of each report page, or lists the current BTITLE definition.
Change	Represents the CHANGE SQLPlus command. In SQLPlus this command changes text on the current line in the buffer.
Clear	Represents the CLEAR SQLPlus command. In SQLPlus this command resets or erases the current clause or setting for the specified option, such as BREAKS or COLUMNS.
Column	Represents the COLUMN SQLPlus command. In SQLPlus this command specifies display characteristics for a given column, or lists the current display characteristics for a single column or for all columns.
Compute	Represents the COMPUTE SQLPlus command. In SQLPlus this command calculates and prints summary lines, using various standard computations, on subsets of selected rows, or lists all COMPUTE definitions.
Connect	Represents the CONNECT SQLPlus command. In SQLPlus this command connects a given user to Oracle.
Copy	Represents the COPY SQLPlus command. In SQLPlus this command copies results from a query to a table in a local or remote database.
Define	Represents the DEFINE SQLPlus command. In SQLPlus this command specifies a user variable and assigns it a CHAR value, or lists the value and variable type of a single variable or all variables.
Del	Represents the DEL SQLPlus command. In SQLPlus this command deletes one or more lines of the buffer.
Describe	Represents the DESCRIBE SQLPlus command. In SQLPlus this command lists the column definitions for the specified table, view, or synonym or the specifications for the specified function or procedure.
Disconnect	Represents the DISCONNECT SQLPlus command. In SQLPlus this command commits pending changes to the database and logs the current user off Oracle, but does not exit SQL*Plus.
Edit	Represents the EDIT SQLPlus command. In SQLPlus this command invokes a host operating system text editor on the contents of the specified file or on the contents of the buffer.
Execute	Represents the EXECUTE SQLPlus command. In SQLPlus this command executes a single PL/SQL statement.
Get	Represents the GET SQLPlus command. In SQLPlus this command loads a host operating system file into the SQL buffer.
Help	Represents the HELP SQLPlus command. In SQLPlus this command accesses the SQL*Plus help system.
Host	Represents the HOST SQLPlus command. In SQLPlus this command executes a host operating system command without leaving SQL*Plus.
Input	Represents the INPUT SQLPlus command. In SQLPlus this command adds one or more new lines after the current line in the buffer.
List	Represents the LIST SQLPlus command. In SQLPlus this command lists one or more lines of the SQL buffer.
Password	Represents the PASSWORD SQLPlus command. In SQLPlus this command allows a password to be changed without echoing the password on an input device.
Pause	Represents the PAUSE SQLPlus command. In SQLPlus this command displays the specified text, then waits for the user to press Return.
Print	Represents the PRINT SQLPlus command. In SQLPlus this command displays the current value of a bind variable.
Prompt	Represents the PROMPT SQLPlus command. In SQLPlus this command sends the specified message to the user's screen.
Quit	Represents the QUIT SQLPlus command. This command terminates SQLPlus and returns control to the operating system.
Recover	Represents the RECOVER SQLPlus command. In SQLPlus this command performs media recovery on one or more tablespaces, one or more datafiles, or the entire database.
Remark	Represents the REMARK SQLPlus command. In SQLPlus this command begins a comment in a script.
Repfooter	Represents the REPFOOTER SQLPlus command. In SQLPlus this command places and formats a specified report footer at the bottom of each report, or lists the current REPFOOTER definition.
Repheader	Represents the REPHEADER SQLPlus command. In SQLPlus this command places and formats a specified report header at the top of each report, or lists the current REPHEADER definition.
Run	Represents the RUN SQLPlus command. In SQLPlus this command lists and executes the SQL command or PL/SQL block currently stored in the SQL buffer.
Save	Represents the SAVE SQLPlus command. In SQLPlus this command saves the contents of the SQL buffer in a host operating system file (a script).
Set	Represents the SET SQLPlus command. In SQLPlus this command sets a system variable to alter the SQL*Plus environment for your current session.
Show	Represents the SHOW SQLPlus command. In SQLPlus this command shows the value of a SQLPlus system variable or the current SQLPlus environment.
Shutdown	Represents the SHUTDOWN SQLPlus command. In SQLPlus this command shuts down a currently running Oracle instance.
Spool	Represents the SPOOL SQLPlus command. In SQLPlus this command stores query results in an operating system file and, optionally, sends the file to a printer.
Start	Represents the START SQLPlus command. In SQLPlus this command executes the contents of the specified script. The script can only be called from a url.
StartEx	Represents the @@ SQLPlus command. In SQLPlus this command runs a script; looks for the specified script in the same path as the script from which it was called.
Startup	Represents the STARTUP SQLPlus command. In SQLPlus this command starts an Oracle instance and optionally mounts and opens a database.
Store	Represents the STORE SQLPlus command. In SQLPlus this command saves attributes of the current SQL*Plus environment in a host operating system file (a script).
Timing	Represents the TIMING SQLPlus command. In SQLPlus this command records timing data for an elapsed period of time, lists the current timer's title and timing data, or lists the number of active timers.
Ttitle	Represents the TTITLE SQLPlus command. In SQLPlus this command places and formats a specified title at the top of each report page, or lists the current TTITLE definition.
Undefine	Represents the UNDEFINE SQLPlus command. In SQLPlus this command deletes one or more user variables that you defined either explicitly (with the DEFINE command) or implicitly (with an argument to the START command).
Unknown	The SQL*Plus command type is not set.
Variable	Represents the VARIABLE SQLPlus command. In SQLPlus this command declares a bind variable that can be referenced in PL/SQL.
Whenever	Represents the "WHENEVER OSERROR" or "WHENEVER SQLERROR" SQLPlus command. This command exits SQLPlus if either an operating system command or SQL command or PL/SQL block generates an error.

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         Devart.Data.Oracle.SqlPlusStatementType

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

Devart.Data.Oracle Namespace
SqlPlusStatementType Property

Send Feedback