B.1 Supported SQL Statements
With a few exceptions, the gateway provides full support for Oracle DELETE
, INSERT
, SELECT
, and UPDATE
statements.
The gateway does not support Oracle data definition language (DDL) statements. No form of the Oracle ALTER
, CREATE
, DROP
, GRANT
, or TRUNCATE
statements can be used. Instead, for ALTER
, CREATE
, DROP
, and GRANT
statements, use the pass-through feature of the gateway if you need to use DDL statements against the Sybase database.
Note:
TRUNCATE
cannot be used in a pass-through statement.
- DELETE
Oracle Database Gateway for Sybase fully supports theDELETE
statement. - INSERT
Oracle Database Gateway for Sybase fully supports theINSERT
statement. - SELECT
Oracle Database Gateway for Sybase supports theSELECT
statement with a few exceptions. - UPDATE
Oracle Database Gateway for Sybase fully supports theUPDATE
statement.
See Also:
Oracle Database SQL Language Reference for detailed descriptions of keywords, parameters, and options and the Sybase documentation for details of executing SQL statements in a transaction.Parent topic: Supported SQL Syntax and Functions
B.1.1 DELETE
Oracle Database Gateway for Sybase fully supports the DELETE
statement.
However, only Oracle functions supported by Sybase can be used.
See Also:
Functions Supported by Sybase for a list of supported functions.Parent topic: Supported SQL Statements
B.1.2 INSERT
Oracle Database Gateway for Sybase fully supports the INSERT
statement.
However, only Oracle functions supported by Sybase can be used.
See Also:
Functions Supported by Sybase for a list of supported functions.Parent topic: Supported SQL Statements
B.1.3 SELECT
Oracle Database Gateway for Sybase supports the SELECT
statement with a few exceptions.
The SELECT
statement is supported, with these exceptions:
CONNECT BY
condition
NOWAIT
START WITH
condition
WHERE CURRENT
OF
Parent topic: Supported SQL Statements
B.1.4 UPDATE
Oracle Database Gateway for Sybase fully supports the UPDATE
statement.
However, only Oracle functions supported by Sybase can be used. Also, you cannot have SQL statements in the subquery that refer to the same table name in the outer query. Subqueries are not supported in the SET
clause.
See Also:
Functions Supported by Sybase for a list of supported functions.Parent topic: Supported SQL Statements