skip to main content
Reference : Supported SQL Statements and Extensions
  

Try DataDirect Drivers Now

Supported SQL Statements and Extensions

The Oracle Service Cloud driver provides support for standard SQL (primarily SQL-92). In addition, the product supports a set of SQL extensions. For example, the product supports extensions that allow you to change the default schema or set the maximum number of Web service calls the driver can make when executing a SQL statement.
This chapter describes both the standard SQL statements and the SQL extensions. SQL extensions are denoted by an (EXT) in the topic title.
* Alter Cache (EXT)
* Alter Index
* Alter Sequence
* Alter Session (EXT)
* Alter Table
* Checkpoint
* Create Cache (EXT)
* Create Index
* Create Sequence
* Create Table
* Create View
* Drop Cache (EXT)
* Drop Index
* Drop Sequence
* Drop Table
* Drop View
* Explain Plan
* Refresh Cache (EXT)
* Set Checkpoint Defrag
* Set Logsize
* Select
* SQL Expressions
* Subqueries