How to convert oracle DDL to mysql DDL


Dear friends,
I have Oracle 9.2.0 DDL, (not complexity, no BLOB or CLOB data type, but have foreign key constrains), I want to convert it to mysql DDL, so I can create mysql database using this DDL. could someone give a hint of how to convert it? thank you very much in advance!
besides, could some one tell me if I can get oracle 9.2.0 DDL through JDBC? how?
thanks again!


Hi Sammy,
I'm not sure what you're looking for when you say you'd like to retrieve Oracle DDL. Would you like to know the table definitions (e.g., table names with associated column names and types)? I think java.sql.DatabaseMetaData might be able to help you out if that's what you mean.
I usually just go into SQL*Plus and ask Oracle to describe the tables I need. But perhaps I'm not understanding you.
Yes, I think it's best combine XDoclet and Hibernate. I've been adding XDoclet javadoc tags to my Java classes. There's an Ant task that generates the *.hbm.xml descriptor files for all my classes. There's another Ant task that will take those descriptors and put out the DLL for you. You can change from Oracle to MySQL just by changing the file.
I agree - Hibernate is terrific stuff. I hope it can help you. Sincerely, MOD

November 30, -0001

How to convert oracle DDL to mysql DDL

Dear friends, I have Oracle 9.2.0 DDL, (not complexity, no BLOB or CLOB data type, but have foreign key constrains), I want to convert it to mysql DDL, so I can create mysql database using this DDL. could someone give a hint of how to convert it? tha

How to convert Oracle reports into excel?

How can we convert Oracle reports into excel. i know there was a thread on this topic which i am not able to find. give the link / help.I found Std Oracle Report output to Excel Sheet has some suggestions. Not being a Reports person anymore I am not

How to convert Oracle scheme into UML

I created Oracle scheme with Toad database modeler. I'm interested how I can convert it into UML diagram? Is there any tool that can convert it?You can use some Tools :- 1-altova 2-microsoft visio, its contain features that allow you to convert to UM

How to convert Oracle database to Sql server Database

Hi All, I have one database made in the Oracle 8i, i want to convert that database to Sql Server Database, Can anyone please give me the step by step process to do this conversion. Regards Ramesh JhaTry using the DTS (data transformation services) se

What should i do with an Oracle 11g Database, MySQL database and a dump file.

I just joining to a new work field, almost about a database and i know "NOTHING" about this field. My company has a system that running by Oracle Database, the problem is that Oracle Database will cost a lot of money when my company expands. So

How to convert java class file version without decompiling

Hi, Oracle R12.1.3 i am having illegal access error while try to access the class file version Java 1.3 uses major version 47,So how to convert the class file version without using decompiling. Current java version is 1.6.0_07 Is there any tool or AP

How to convert the Object into tonumber

Hi all, How to convert a date in Object type into a number type. eg: Object EVENT_NUMBER = ADFContext.getCurrent().getSessionScope().get("SV_EVENT_NUMBER"); Number LV_N_EVENT_NUMBER = EVENT_NUMBER.*toNumber();* I need to assign the value in numb

How to convert CLOB to BLOB with SQL Developer migration wizard?

Hi, According to our requirement, we need to only migrate data from SQL Server 2008 to Oracle 11. I use the SQL Developer 3.0.04 migration wizard to do it. I do migration from SQL Server (database name: SCDS41P2) to Oracle (User name: HCDS41P2). My m

How to convert a data set into a xml data and vice versa

i am new to oracle with xml.. my aim is to convert a data set into a xml data and vice versa.. my work is as follows... my query: select rggpk,rggcode,rggname from ms_regiongeo to convert a data set into a xml* select XMLType(trim(replace(dbms_xmlgen

How to convert logical standby database to Physical Standby Database

Hi, Does anyone know how to convert logical standby database( to Physical Standby Database( Is this possible? If so,please give me steps for it. Thanks. Regards, RJ.I don't believe this to be possible. One of the steps invloved in

How to convert database table into xml file

Hi. How to convert database table into XML file in Oracle HTML DB. Please let me know. Thanks.This not really a specific APEX question... but I search the database forum and found this thread which I think will help Exporting Oracle table to XML If i

How to convert a number stored as text to as integer with formating

Hi, Can someone say me how to convert a Numeric data that is stored in a Varchar column to an integer. Say, I have a Value "-.84566666" in a column which is of data type VARCHAR and I want to show this data as "-0.8456", i.e. I want to

How to convert sysdate to the format dd-mon-yyyy

how to convert sysdate to the format dd-mon-yyyy<how to convert sysdate to the format dd-mon-yyyy> This question is better answered by thinking about about how Oracle dates work. SYSDATE is a pseudocolumn (function without any arguments) that return

How to convert date in varchar format to TimeZone format?

Hi, Iam having a date '14-05-08 09:46:35 AM' (in Varchar format). How to convert this date to TimeZone ('IYYY-MM-DD"T"HH12:MI:SS"Z"FX') format? For Example, My input date is '14-05-08 09:46:35 AM' and I need output as '2008-05-14T09:46

Converted Oracle 6i Report

Hi All, I used BI Publisher conversion utility to convert oracle report 6i to BI Publisher. In the following XML template file i got few quries. I need a hint how can i migrate this report to APEX. Thanks. Ribhi <?xml version="1.0" encoding=&

How to convert a Logical Standby DB to a Primary

Hi, I have an issue with our Data Guarded cluster (two nodes, one Primary and one Logical Standby Oracle 10i DBs running on HP-UX 11.23) The issue is that for some reasons the Primary and the Standby are out of sync in terms of archive log sequences.

How to convert table to control

In my attached VIS, I am giving user input values to controls,the user input control values i am passing to a table and writing text can i do exactly opposite of that what i am doing now.that means reading same text file(that i already writt

How to convert from integer to string

import javax.swing.*; import java.awt.*; public class Hw extends JFrame{      JButton[] buttons = new JButton[26];      public Hw(){           getContentPane().setLayout(new GridLayout(2,13));           JButton []buttons=new JButton[26];           fo

How to install Oracle spatial in existing 10g database

Hi all, I am using Oracle 10g on Windows. How to install Oracle spatial in my database. I tried to do with DBCA with configure database option but in that Oracle spatial is in disabled state. Please help I am newby to Oracle spatial -Thank

How to Convert binary file to s-records

Hi all, can anybody help how to convert binary ".bin" files to s-record ".s" files any idea or code snippets are very appreciated best regards, gebiThere is a ready-made converter: "BINARY to Motorola S-Record Conveter Utility&quo