Re: Unload data

tonik wrote:
> I want to unload data from table in oracle to table in another
> database,for example DB2.
>
> Can you help me with a sample code?
> thanks!
>

There should be some commercial/noncomercial programs on the market, but only with PL/SQL I would make a SELECT that returns INSERT statements. Something like bellow:

SELECT 'INSERT INTO table_name (col1int,col2varchar,...) VALUES ('||col1int||','''||col2varchar||''',...);' FROM table_name;

Depends also on number of tables to be transported (should be crazy when more than 10 ;-)).

Regards

   Primz Received on Fri May 27 2005 - 13:05:50 CEST