Supported SQL Statements

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, use the pass-through feature of the gateway if you need to use DDL statements against the SQL Server database.

Note:

TRUNCATE cannot be used in a pass-through statement.

DELETE
The DELETE statement is fully supported.
INSERT
The INSERT statement is fully supported.
SELECT
The SELECT statement is fully supported.
UPDATE
The UPDATE statement is fully supported.

See Also:

Oracle Database Reference for detailed descriptions of keywords, parameters, and options.

Parent topic: Supported SQL Syntax and Functions

B.1.1 DELETE

The DELETE statement is fully supported.

However, only Oracle functions supported by SQL Server can be used.

See Also:

Functions Supported by SQL Server for a list of supported functions.

Parent topic: Supported SQL Statements

B.1.2 INSERT

The INSERT statement is fully supported.

However, only Oracle functions supported by SQL Server can be used.

See Also:

Functions Supported by SQL Server for a list of supported functions.

Parent topic: Supported SQL Statements

B.1.3 SELECT

The SELECT statement is fully supported.

However, only Oracle functions supported by SQL Server can be used.

CONNECT BY condition
NOWAIT
START WITH condition
WHERE CURRENT OF

Parent topic: Supported SQL Statements

B.1.4 UPDATE

The UPDATE statement is fully supported.

However, only Oracle functions supported by SQL Server can be used.

See Also:

Functions Supported by SQL Server for a list of supported functions.

Parent topic: Supported SQL Statements