'Declaration Public ReadOnly Property OrderBy As SelectColumnCollection
public SelectColumnCollection OrderBy {get;}
'Declaration Public ReadOnly Property OrderBy As SelectColumnCollection
public SelectColumnCollection OrderBy {get;}
OracleSelectStatement stmt = new OracleSelectStatement(); SelectColumn empName = new SelectColumn("ENAME"); stmt.Columns.Add(empName); stmt.Tables.Add(new SelectTable("emp")); stmt.OrderBy.Add(empName); //select ENAME from emp order by ENAME OracleCommand command = new OracleCommand(stmt.ToString());
Dim stmt As New OracleSelectStatement Dim empName As New SelectColumn("ENAME") stmt.Columns.Add(empName) stmt.Tables.Add(New SelectTable("emp")) stmt.OrderBy.Add(empName) 'select ENAME from emp order by ENAME Dim command5 As New OracleCommand(stmt.ToString)