Oracle Database discussion

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Unload data

tonik

2005-05-27, 3:23 am

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!

Primo¾ Govekar

2005-05-27, 7:23 am

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

Sponsored Links