B.2 Oracle Functions
All functions are evaluated by the Sybase database after the gateway has converted them to Sybase SQL.
- Functions Not Supported by Sybase
Oracle SQL functions with no equivalent function in Sybase are not supported inDELETE
,INSERT
, orUPDATE
statements, but are evaluated by the Oracle database if the statement is aSELECT
statement. - Functions Supported by Sybase
The gateway translates the following Oracle database functions in SQL statements to their equivalent Sybase functions.
Parent topic: Supported SQL Syntax and Functions
B.2.1 Functions Not Supported by Sybase
Oracle SQL functions with no equivalent function in Sybase are not supported in DELETE
, INSERT
, or UPDATE
statements, but are evaluated by the Oracle database if the statement is a SELECT
statement.
That is, the Oracle database performs post-processing of SELECT
statements sent to the gateway.
If an unsupported function is used in a DELETE
, INSERT
, or UPDATE
, statement, the following Oracle error occurs:
ORA-02070: database db_link_name does not support function in this context
Parent topic: Oracle Functions
B.2.2 Functions Supported by Sybase
The gateway translates the following Oracle database functions in SQL statements to their equivalent Sybase functions.
- Arithmetic Operators
Arithmetic operators suppoted by Oracle Database Gateway for Sybase. - Comparison Operators
Comparison operators supported by Oracle Database Gateway for Sybase. - Group Functions
Group functions supported by Oracle Database Gateway for Sybase. - String Functions
String functions supported by Oracle Database Gateway for Sybase. - Other Functions
Other functions supported by Oracle Database Gateway for Sybase.
Parent topic: Oracle Functions
B.2.2.1 Arithmetic Operators
Arithmetic operators suppoted by Oracle Database Gateway for Sybase.
Oracle | Sybase |
---|---|
|
|
|
|
|
|
|
|
Parent topic: Functions Supported by Sybase
B.2.2.2 Comparison Operators
Comparison operators supported by Oracle Database Gateway for Sybase.
Oracle | Sybase |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Parent topic: Functions Supported by Sybase
B.2.2.3 Group Functions
Group functions supported by Oracle Database Gateway for Sybase.
Oracle | Sybase |
---|---|
|
|
|
|
|
|
|
|
|
|
Parent topic: Functions Supported by Sybase
B.2.2.4 String Functions
String functions supported by Oracle Database Gateway for Sybase.
Oracle | Sybase |
---|---|
|
+ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Parent topic: Functions Supported by Sybase
B.2.2.5 Other Functions
Other functions supported by Oracle Database Gateway for Sybase.
Oracle | Sybase |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Parent topic: Functions Supported by Sybase