'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
'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
Member | Description |
---|---|
Accept | Represents the ACCEPT SQL*Plus command. In SQL*Plus this command reads a line of input and stores it in a given user variable. |
Append | Represents the APPEND SQL*Plus command. In SQL*Plus this command adds specified text to the end of the current line in the buffer. |
Archive | Represents the ARCHIVE SQL*Plus command. In SQL*Plus 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 SQL*Plus command. In SQL*Plus 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 SQL*Plus command. In SQL*Plus this command specifies where and how formatting will change in a report, or lists the current break definition. |
Btitle | Represents the BTITLE SQL*Plus command. In SQL*Plus 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 SQL*Plus command. In SQL*Plus this command changes text on the current line in the buffer. |
Clear | Represents the CLEAR SQL*Plus command. In SQL*Plus this command resets or erases the current clause or setting for the specified option, such as BREAKS or COLUMNS. |
Column | Represents the COLUMN SQL*Plus command. In SQL*Plus 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 SQL*Plus command. In SQL*Plus 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 SQL*Plus command. In SQL*Plus this command connects a given user to Oracle. |
Copy | Represents the COPY SQL*Plus command. In SQL*Plus this command copies results from a query to a table in a local or remote database. |
Define | Represents the DEFINE SQL*Plus command. In SQL*Plus 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 SQL*Plus command. In SQL*Plus this command deletes one or more lines of the buffer. |
Describe | Represents the DESCRIBE SQL*Plus command. In SQL*Plus 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 SQL*Plus command. In SQL*Plus 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 SQL*Plus command. In SQL*Plus 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 SQL*Plus command. In SQL*Plus this command executes a single PL/SQL statement. |
Get | Represents the GET SQL*Plus command. In SQL*Plus this command loads a host operating system file into the SQL buffer. |
Help | Represents the HELP SQL*Plus command. In SQL*Plus this command accesses the SQL*Plus help system. |
Host | Represents the HOST SQL*Plus command. In SQL*Plus this command executes a host operating system command without leaving SQL*Plus. |
Input | Represents the INPUT SQL*Plus command. In SQL*Plus this command adds one or more new lines after the current line in the buffer. |
List | Represents the LIST SQL*Plus command. In SQL*Plus this command lists one or more lines of the SQL buffer. |
Password | Represents the PASSWORD SQL*Plus command. In SQL*Plus this command allows a password to be changed without echoing the password on an input device. |
Pause | Represents the PAUSE SQL*Plus command. In SQL*Plus this command displays the specified text, then waits for the user to press Return. |
Represents the PRINT SQL*Plus command. In SQL*Plus this command displays the current value of a bind variable. | |
Prompt | Represents the PROMPT SQL*Plus command. In SQL*Plus this command sends the specified message to the user's screen. |
Quit | Represents the QUIT SQL*Plus command. This command terminates SQL*Plus and returns control to the operating system. |
Recover | Represents the RECOVER SQL*Plus command. In SQL*Plus this command performs media recovery on one or more tablespaces, one or more datafiles, or the entire database. |
Remark | Represents the REMARK SQL*Plus command. In SQL*Plus this command begins a comment in a script. |
Repfooter | Represents the REPFOOTER SQL*Plus command. In SQL*Plus 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 SQL*Plus command. In SQL*Plus 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 SQL*Plus command. In SQL*Plus this command lists and executes the SQL command or PL/SQL block currently stored in the SQL buffer. |
Save | Represents the SAVE SQL*Plus command. In SQL*Plus this command saves the contents of the SQL buffer in a host operating system file (a script). |
Set | Represents the SET SQL*Plus command. In SQL*Plus this command sets a system variable to alter the SQL*Plus environment for your current session. |
Show | Represents the SHOW SQL*Plus command. In SQL*Plus this command shows the value of a SQL*Plus system variable or the current SQL*Plus environment. |
Shutdown | Represents the SHUTDOWN SQL*Plus command. In SQL*Plus this command shuts down a currently running Oracle instance. |
Spool | Represents the SPOOL SQL*Plus command. In SQL*Plus this command stores query results in an operating system file and, optionally, sends the file to a printer. |
Start | Represents the START SQL*Plus command. In SQL*Plus this command executes the contents of the specified script. The script can only be called from a url. |
StartEx | Represents the @@ SQL*Plus command. In SQL*Plus 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 SQL*Plus command. In SQL*Plus this command starts an Oracle instance and optionally mounts and opens a database. |
Store | Represents the STORE SQL*Plus command. In SQL*Plus this command saves attributes of the current SQL*Plus environment in a host operating system file (a script). |
Timing | Represents the TIMING SQL*Plus command. In SQL*Plus 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 SQL*Plus command. In SQL*Plus 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 SQL*Plus command. In SQL*Plus 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 SQL*Plus command. In SQL*Plus this command declares a bind variable that can be referenced in PL/SQL. |
Whenever | Represents the "WHENEVER OSERROR" or "WHENEVER SQLERROR" SQL*Plus command. This command exits SQL*Plus if either an operating system command or SQL command or PL/SQL block generates an error. |
System.Object
System.ValueType
System.Enum
Devart.Data.Oracle.SqlPlusStatementType