See Also

OracleSelectStatement Members  | Devart.Data.Oracle Namespace

Language

Visual Basic

C#

Show All

See AlsoLanguagesDevart.Data.OracleSend comments on this topic.

OracleSelectStatement Class

Devart.Data.Oracle Namespace : OracleSelectStatement Class

Represents a SELECT statement.

For a list of all members of this type, see OracleSelectStatement members.

Inheritance Hierarchy

System.Object
   Devart.Common.SelectStatement
      Devart.Data.Oracle.OracleSelectStatement

Syntax

[Visual Basic]
Public NotInheritable Class OracleSelectStatement 
   Inherits SelectStatement
[C#]
public sealed class OracleSelectStatement : SelectStatement

Example

The following example demonstrates how to use the OracleSelectStatement class.

[C#] 

OracleSelectStatement stmt = new OracleSelectStatement(); 
 
stmt.Columns.Add(new SelectColumn("test", "td", "dname", "Department")); 
stmt.Columns.Add(new SelectColumn("", "td", "loc", "Location")); 
stmt.Columns.Add(new SelectColumn("", "te", "ename", "Name")); 
 
stmt.Tables.Add(new SelectTable("test", "dept", "td")); 
stmt.Tables.Add(new SelectTable("", "emp", "te")); 
 
stmt.GroupBy.Add(new SelectColumn("", "te", "empno", "")); 
stmt.OrderBy.Add(new SelectColumn("", "te", "ename", "")); 

[Visual Basic] 

Dim stmt As New OracleSelectStatement

stmt.Columns.Add(New SelectColumn("test", "td", "dname", "Department"))
stmt.Columns.Add(New SelectColumn("", "td", "loc", "Location"))
stmt.Columns.Add(New SelectColumn("", "te", "ename", "Name"))

stmt.Tables.Add(New SelectTable("test", "dept", "td"))
stmt.Tables.Add(New SelectTable("", "emp", "te"))

stmt.GroupBy.Add(New SelectColumn("", "te", "empno", ""))
stmt.OrderBy.Add(New SelectColumn("", "te", "ename", ""))

See Also

OracleSelectStatement Members  | Devart.Data.Oracle Namespace

 

 

© 2002 - 2013 Devart. All Rights Reserved.