MySQL Forums
Forum List  »  Oracle

Re: Importing from Oracle into MySQL
Posted by: Salvatore Baglieri
Date: February 03, 2007 01:33AM

David Beckedorff Wrote:
-------------------------------------------------------
> So now I'm using SQL*Plus in batch mode on the
> Oracle side to generate insert statements from
> tables of interest, outputting to SQL script
> files. That works fine.

How? I'm looking for this!
I've an old Oracle version, not supported by MySQL Migration Toolkit.

How can i use SQL*Plus to generate sql statements from a select?

ex: "select * from table where nation=italy > ciccio.sql"

(it's just pseudocode...)

Options: ReplyQuote


Subject
Views
Written By
Posted
3987
January 22, 2007 12:48AM
4618
March 30, 2005 06:13PM
Re: Importing from Oracle into MySQL
4200
February 03, 2007 01:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.