I'm not familiar with mysql but follow the leads on how to create a .csv file containing you data and use that .csv to import into mysql.
I would be suprised if mysql didn't have the ability to import a .csv
You can extract the data to text file with columns separated by comma or a tab or any other character. This text file can be read by mysql.
Extraction can be done like this:
SQL>set heading off
SQL>set pages 0
SQL>set feedback off
SQL>set echo off
SQL>set linesize n
n is the number that you have to specify depending the maximum length a record that is extracted.
SQL>set colsep ','
SQL>select * from table_name;
Originally posted by b3njo
i've tried that one, but mysql gave out an error msg, something about expected ". i'll post details later when i'm at the office.
the problem i'm having right now is on how to use the oracle interface to export the table to something mysql understand.