C.2 Accessing the Gateway Data Dictionary
Accessing a gateway data dictionary table or view is identical to accessing a data dictionary in an Oracle database.
You issue a SQL SELECT
statement specifying a database link. The Oracle database data dictionary view and column names are used to access the gateway data dictionary in an Oracle database. Synonyms of supported views are also acceptable. For example, the following statement queries the data dictionary table ALL_CATALOG
to retrieve all table names in the Sybase database:
SQL> SELECT * FROM "ALL_CATALOG"@SYBS;
When a data dictionary access query is issued, the gateway:
Parent topic: Data Dictionary