Need script to generate sql for inserting data into table
From: Susan Dahl <dahlsg_at_usano.ksc.nasa.gov>
Date: 1997/04/08
Message-ID: <334A5457.1825_at_usano.ksc.nasa.gov>#1/1
Date: 1997/04/08
Message-ID: <334A5457.1825_at_usano.ksc.nasa.gov>#1/1
I am hoping someone will already have written this. I have written a script to create another script that contains insert statements with the data values I need. But I now want to make that script dynamic, so I will not have to hard code the column names, but rather get them from all_tab_columns. As a second phase I want to get the values for those columns, ultimately to concatenate with the 'insert into ...' part of the stmt.
Has anyone done this? Or have any suggestions?
Thanks!!
Susan
Received on Tue Apr 08 1997 - 00:00:00 CEST