How to convert Oracle views into MySQL format
|[Oracle to MySQL Converter] [About Migration]
Migration of Oracle database to MySQL envolves translating
statements into MySQL format. Syntax of statements to create views in Oracle and
MySQL is similar but not identical. The primary difference is that two DBMS provide
distinguished sets of built-in functions. That's why it is necessary to process each
of those statement before passing it to the destination database management system.
This article discovers basic techniques of converting Oracle views into MySQL format.
The target audience for this guide should have general database management knowledge
and experience in composing SQL queries.
SELECT ... FROM a,b WHERE a.id=b.id(+)In MySQL:
SELECT ... FROM a LEFT JOIN b ON b.id = a.id
where rownum <= 50 are
limit 50 in MySQL