This is an old revision of the document!
SQLines tool allows you to convert database schema (DDL), views, stored procedures, functions, triggers, queries, SQL scripts and embedded SQL from Microsoft SQL Server to Oracle.
SQLines is available in Online, Lite, Standard, Professional and Enterprise editions:
Try SQLines Online or download a Trial Version.
If any you have any questions or need any assistance, please contact us at support@sqlines.com.
SQL conversion features supported by SQLines tool. For more information, also see SQL Server to Oracle Migration Reference.
Converting functions:
SQL Server | Oracle | ||
1 | YEAR(datetime) | Extract year from datetime | EXTRACT(YEAR FROM datetime) |