how to convert oracle to mysql

[Randeep Mann]

Hi Guys,

One way to do it is to query the object's structure trough SQL using JDBC, then you will have all the information you need available in Record sets (data-types, names...)In Oracle in order to get all tables (or other types of objects) you can:
SELECT Object_Name,Object_ID FROM user_objects WHERE Object_Type='TABLE'
Then you can iterate trough the resulting Recordset and for each table you have gotten on the previous query. get the column structure like this:SELECT * From user_tab_columns WHERE Table_Name='TableName'This way you can conditionaly build up Create table statements with proper datatype mappings.The same method could be used for any type of objects.Doing the same from Oracle to SQL Server a pain in the arse..

Good luck...