OracleSelectStatement stmt = new OracleSelectStatement(); stmt.Columns.Add(new SelectColumn("ENAME")); stmt.Tables.Add(new SelectTable("emp")); stmt.Where = "1000 < SAL AND SAL < 1500 OR JOB = 'SALESMAN'"; OracleCommand command = new OracleCommand(stmt.ToString());
Dim stmt As New OracleSelectStatement stmt.Columns.Add(New SelectColumn("ENAME")) stmt.Tables.Add(New SelectTable("emp")) stmt.Where = "1000 < SAL AND SAL < 1500 OR JOB = 'SALESMAN'" Dim command As New OracleCommand(stmt.ToString)