Using Oracle SQL Developer, We can convert any 3rd party SQL procedures into Oracle (PL/SQL)
Sample Example (Convert SQL Server procedure into Oracle) as shown below
Step 1; we have the option in Oracle SQL Developer using Migration menu.
From Migration menu, select Translation Scratch Editor
Refer screen shot below:
Step 2; Get SQL Server stored procedure
Copy the stored procedure from SQL SERVER into Scratch Editor window (3rd party SQL window)
Step 3; Translate SQL Server procedure into oracle
Select translate option as shown below
We can convert any other 3rd party sql procedure (like Access SQL to Oracle, Sybase Sql to Oracle and SQL Server T-Sql into Oracle (PL/SQL)).
Step4: Output
The procedure automatically translates from SQL procedure into Oracle (PL/SQL) procedure.
