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.

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.

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.

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

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.