dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / SqlPlusStatementType Enumeration

In This Topic
    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
    'Declaration
     
    Public Enum SqlPlusStatementType 
       Inherits System.Enum
       Implements System.IComparableSystem.IConvertibleSystem.IFormattable 
    public enum SqlPlusStatementType : System.Enum, System.IComparableSystem.IConvertibleSystem.IFormattable  
    Members
    MemberDescription
    AcceptRepresents the ACCEPT SQL*Plus command. In SQL*Plus this command reads a line of input and stores it in a given user variable.
    AppendRepresents the APPEND SQL*Plus command. In SQL*Plus this command adds specified text to the end of the current line in the buffer.
    ArchiveRepresents 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.
    AttributeRepresents 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.
    BreakRepresents 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.
    BtitleRepresents 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.
    ChangeRepresents the CHANGE SQL*Plus command. In SQL*Plus this command changes text on the current line in the buffer.
    ClearRepresents 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.
    ColumnRepresents 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.
    ComputeRepresents 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.
    ConnectRepresents the CONNECT SQL*Plus command. In SQL*Plus this command connects a given user to Oracle.
    CopyRepresents the COPY SQL*Plus command. In SQL*Plus this command copies results from a query to a table in a local or remote database.
    DefineRepresents 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.
    DelRepresents the DEL SQL*Plus command. In SQL*Plus this command deletes one or more lines of the buffer.
    DescribeRepresents 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.
    DisconnectRepresents 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.
    EditRepresents 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.
    ExecuteRepresents the EXECUTE SQL*Plus command. In SQL*Plus this command executes a single PL/SQL statement.
    GetRepresents the GET SQL*Plus command. In SQL*Plus this command loads a host operating system file into the SQL buffer.
    HelpRepresents the HELP SQL*Plus command. In SQL*Plus this command accesses the SQL*Plus help system.
    HostRepresents the HOST SQL*Plus command. In SQL*Plus this command executes a host operating system command without leaving SQL*Plus.
    InputRepresents the INPUT SQL*Plus command. In SQL*Plus this command adds one or more new lines after the current line in the buffer.
    ListRepresents the LIST SQL*Plus command. In SQL*Plus this command lists one or more lines of the SQL buffer.
    PasswordRepresents the PASSWORD SQL*Plus command. In SQL*Plus this command allows a password to be changed without echoing the password on an input device.
    PauseRepresents the PAUSE SQL*Plus command. In SQL*Plus this command displays the specified text, then waits for the user to press Return.
    PrintRepresents the PRINT SQL*Plus command. In SQL*Plus this command displays the current value of a bind variable.
    PromptRepresents the PROMPT SQL*Plus command. In SQL*Plus this command sends the specified message to the user's screen.
    QuitRepresents the QUIT SQL*Plus command. This command terminates SQL*Plus and returns control to the operating system.
    RecoverRepresents 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.
    RemarkRepresents the REMARK SQL*Plus command. In SQL*Plus this command begins a comment in a script.
    RepfooterRepresents 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.
    RepheaderRepresents 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.
    RunRepresents 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.
    SaveRepresents 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).
    SetRepresents the SET SQL*Plus command. In SQL*Plus this command sets a system variable to alter the SQL*Plus environment for your current session.
    ShowRepresents 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.
    ShutdownRepresents the SHUTDOWN SQL*Plus command. In SQL*Plus this command shuts down a currently running Oracle instance.
    SpoolRepresents 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.
    StartRepresents 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.
    StartExRepresents 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.
    StartupRepresents the STARTUP SQL*Plus command. In SQL*Plus this command starts an Oracle instance and optionally mounts and opens a database.
    StoreRepresents 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).
    TimingRepresents 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.
    TtitleRepresents 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.
    UndefineRepresents 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).
    UnknownThe SQL*Plus command type is not set.
    VariableRepresents the VARIABLE SQL*Plus command. In SQL*Plus this command declares a bind variable that can be referenced in PL/SQL.
    WheneverRepresents 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.
    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

    See Also