Install SQL Translator

This dialog box is displayed if you right-click SQL Translators under SQL Translator FrameWork for a connection in the DBA navigator (see Using DBA Features in SQL Developer) and select Install SQL Translator.

SQL Translator: SQL translator to be installed for the desired third-party SQL to be translated (for example, Sybase SQL Translator for Sybase).

Mode: online lets you perform the installation interactively in SQL Developer; offline creates a .zip file containing several files, including a Linux .sh file that you can run to perform the installation.

Create New Profile: If this option is checked, you can also create a new SQL translator profile associated with the translator being created. In this case, specify a name for the profile (for example, sybase_profile) and an existing Oracle database schema to own the profile. Whether you check this option or not, you can also create new profiles separately.

Click Apply to start the installation of the SQL translator. (This installation involves several steps, and it may take a long time.)

Installing a Translator and Creating a Profile: Usage Notes

Installing a SQL translator is an Oracle schema enables you to run third-party statements and procedures, have SQL Developer automatically translate them to Oracle syntax, and see the results you would expect from Oracle.

Install the SQL translator in an Oracle schema where the user has been granted the usual privileges for connecting and creating database objects, as well as the CREATE SQL TRANSACTION PROFILE privilege. For example:

GRANT CREATE SQL TRANSACTION PROFILE to USER3;

After you click Apply, SQL Developer checks if the database user has the necessary privileges; and if it does not, it prompts you to log in as the SYS user and then confirm the granting of certain privileges.

The actual translator installation can take a long time, during which the Online SQL Translator Install progress box is displayed. If you want to continue working in SQL Developer during the installation, you can click Run in Background.

After the installation, grant execute access on the translator to the database user. For example:

GRANT EXECUTE on SYBASE_TSQL_TRANSLATOR to USER3;

You can now right-click a profile that is associated with the translator and select Open SQL Worksheet with Profile. In the SQL worksheet that is displayed, you can run SQL statements and procedures in that third-party SQL. For example, in the worksheet for a profile associated with the SYBASE_TSQL_TRANSLATOR translator, you could enter the following Sybase syntax that is not recognized by native Oracle Database:

select top 5 * from my_table;

If you double-click the profile name in the DBA navigator and then select the SQL Translations tab, you can see the SQL text and the translated text for each statement executed. If you want, and if you are sufficiently knowledgeable, you can modify the TRANSLATED_TEXT cells for selected statements to change the way they are interpreted and executed by Oracle.