Class Query
Oracle Query class - this should be considered to be beta.
Inherited Members
Namespace: DataTables.DatabaseUtil.Oracle
Assembly: DataTables-Editor-Server.dll
Syntax
public class Query : Query
Constructors
| Improve this Doc View SourceQuery(Database, String)
Create a query instance specifically for Oracle
Declaration
public Query(Database db, string type)
Parameters
Type | Name | Description |
---|---|---|
Database | db | Host database |
System.String | type | Query type |
Methods
| Improve this Doc View Source_BuildLimit()
Create LIMIT / OFFSET for SQL Server 2012+. Note that this will only work with SQL Server 2012 or newer due to the use of the OFFSET and FETCH NEXT keywords
Declaration
protected override string _BuildLimit()
Returns
Type | Description |
---|---|
System.String | Limit / offset string |
Overrides
| Improve this Doc View Source_BuildTable()
Oracle table statement
Declaration
protected override string _BuildTable()
Returns
Type | Description |
---|---|
System.String | SQL for the table |
Overrides
| Improve this Doc View Source_Exec()
Execute the SQL command
Declaration
protected override Result _Exec()
Returns
Type | Description |
---|---|
Result | Result instance |
Overrides
| Improve this Doc View Source_Prepare(String)
Bind parameters to the SQL statement
Declaration
protected override void _Prepare(string sql)
Parameters
Type | Name | Description |
---|---|---|
System.String | sql | SQL command |
Overrides
| Improve this Doc View SourceInit(Database)
Initialise the Oracle session
Declaration
public static void Init(Database dbh)
Parameters
Type | Name | Description |
---|---|---|
Database | dbh |