This is an old revision of the document!
SQLines tool allows you to convert database schema (DDL), views, stored procedures, packages, functions, triggers, queries, SQL scripts and embedded SQL from Sybase Adaptive Server Enterprise to Oracle.
SQLines is available in Standard, Professional and Enterprise editions:
Try SQLines Online or download a Trial Version (no registration required).
If any you have any questions or need any assistance, please contact us at support@sqlines.com.
Supported SQL conversion features:
Converting Transact-SQL language:
Sybase ASE | Oracle |
Optional statement delimiter | Adding ; |
Conversion of Transact-SQL stored procedures:
Sybase ASE | Oracle |
CREATE PROC | CREATE OR REPLACE PROCEDURE |
Procedure body without BEGIN END | Adding BEGIN END |
Returning result set using SELECT | Adding OPEN cur FOR SELECT and OUT SYS_REFCURSOR parameter |
GO | Replacing with / |
Conversion of SQL statements:
Sybase ASE | Oracle |
CREATE PROC | CREATE OR REPLACE PROCEDURE |