OracleSelectStatement Class

On this page

Represents a SELECT statement.

Syntax

Visual Basic
C#


'Declaration Public NotInheritable Class OracleSelectStatement Inherits Devart.Common.SelectStatement


public sealed class OracleSelectStatement : Devart.Common.SelectStatement

Example

The following example demonstrates how to use the OracleSelectStatement class.

csharp


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", ""));

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", ""))

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", ""))

Inheritance Hierarchy

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

Reference

OracleSelectStatement Members
Devart.Data.Oracle Namespace

Send Feedback