dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / OracleSelectStatement Class / OracleSelectStatement Constructor
Example

In This Topic
    OracleSelectStatement Constructor
    In This Topic
    Creates a new instance of the OracleSelectStatement class.
    Syntax
    'Declaration
     
    Public Function New()
    public OracleSelectStatement()
    Example
    The following example demonstrates how to use the OracleSelectStatement constructor.
    OracleSelectStatement stmt = new OracleSelectStatement();
    stmt.Columns.Add(new SelectColumn("JOB"));
    stmt.Tables.Add(new SelectTable("emp"));
    
    stmt.Distinct = true;
    
    //select distinct JOB from emp
    string queryText = stmt.ToString();
    Dim stmt As New OracleSelectStatement
    stmt.Columns.Add(New SelectColumn("JOB"))
    stmt.Tables.Add(New SelectTable("emp"))
    stmt.Distinct = True
    
    'select distinct JOB from emp
    Dim queryText As String = stmt.ToString
    See Also