Re: from DB2 to Oracle8

From: Jeffrey Boulier <jeffreyb_at_gwu.edu>
Date: 2000/07/30
Message-ID: <dp0h5.3307$J7.33006@grover.nit.gwu.edu>#1/1

In article <8jj3ub$1i$1_at_news6.svr.pol.co.uk>, Jim Harrison <jim_at_colway.net> wrote:
> Generate lots of insert statements eg: SELECT 'INSERT INTO ORA_TAB
>(col1, col2...) VALUES('||col1||','||col2||',...)' FROM DB2_TAB; Then run
>the SQL script against your Oracle table.

Has anyone written a script to automate the above? Handling cases when one of the fields in a particular row happens to be NULL and therefore the column and the extra comma need to be stripped from the INSERT is incredibly time consuming.

			Yours Truly,
			Jeffrey Boulier

Received on Sun Jul 30 2000 - 00:00:00 CDT