From: primz@gora.si   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)