dotConnect for Oracle Documentation
Devart.Common Namespace / SelectStatement Class
Properties Methods

SelectStatement Class Members

The following tables list the members exposed by SelectStatement.

Public Properties
 NameDescription
Public PropertyGets or sets the value, indicating if the all records are selected or only the unique ones.  
Public PropertyContains list of columns and expressions used in the select-list of the current SelectStatement object.  
Public PropertyGets or sets whether statement should request unique rows only.  
Public PropertyContains list of columns used in the GROUP BY clause of the current SelectStatement object.  
Public PropertyGets or sets HAVING clause of the statement.  
Public PropertyContains list of columns used in the ORDER BY clause of the current SelectStatement object.  
Public PropertyContains list of tables and subqueries used in the FROM clause of the current SelectStatement object.  
Public PropertyGets or sets WHERE clause of the statement.  
Top
Public Methods
 NameDescription
Public MethodAdds new condition to HAVING clause of the statement, represented by the Having property.  
Public MethodAdds new condition to WHERE clause of the statement, represented by the Where property.  
Public MethodClears all parts of the SelectStatement.  
Public MethodReturns SQL statement in the text form.  
Top
See Also