dotConnect for Oracle Documentation
Devart.Common Namespace / SelectColumn Class
Members Example

In This Topic
    SelectColumn Class
    In This Topic
    Represents a column or an expression in SELECT, GROUP BY and ORDER BY clauses of a SQL statement.
    Syntax
    'Declaration
     
    Public NotInheritable Class SelectColumn 
       Inherits SelectStatementNode
    public sealed class SelectColumn : SelectStatementNode 
    Example

    This example shows how SelectColumns can be used to create a SelectStatement object representing the following query:

    SELECT test.dept.dname Department, test.dept.loc Location
        FROM test.dept
    
    OracleSelectStatement statement = new OracleSelectStatement();
    
    // Create columns. Specify their schema, tables to which they belong, their names and aliases.
    SelectColumn cName = new SelectColumn("test", "dept", "dname", "Department");
    SelectColumn cLoc = new SelectColumn("test", "dept", "loc", "Location");
    
    statement.Columns.Add(cName);
    statement.Columns.Add(cLoc);
    
    statement.Tables.Add(new SelectTable("test", "dept", ""));
    Dim statement As OracleSelectStatement = New OracleSelectStatement()
    
    ' Create columns. Specify their schema, tables to which they belong, their names and aliases.
    Dim cName = New SelectColumn("test", "dept", "dname", "Department")
    Dim cLoc = New SelectColumn("test", "dept", "loc", "Location")
    
    statement.Columns.Add(cName)
    statement.Columns.Add(cLoc)
    
    statement.Tables.Add(New SelectTable("test", "dept", ""))
    Inheritance Hierarchy

    System.Object
       Devart.Common.SelectStatementNode
          Devart.Common.SelectColumn

    See Also