OraFAQ Forum: SQL & PL/SQL » INSERT scripts from table data

Home » SQL & PL/SQL » SQL & PL/SQL » INSERT scripts from table data

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

INSERT scripts from table data [message #162963]

Tue, 14 March 2006 06:24

pjose
Messages: 6
Registered: September 2005
Location: NJ

Junior Member

I'm in Oracle9.2.0.5.

Looking to create insert script from table data. Tables are large in the sense around 80-90 fields and hence, creating the script using select statement would be tedious, I guess. Looking for some general method to do so.

I know that we could do easily in TOAD. Not sure if we could do the same using some DBMS packages.

Thanks.

Report message to a moderator

Re: INSERT scripts from table data [message #163059 is a reply to message #162963]

Tue, 14 March 2006 19:32

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

I have an Excel macro that uses the Sheet names for table names, and the first row for column names, and generates INSERT statements from there. I can post it if you're interested.

If the data is already in Oracle and you just want to generate a portable script, AskTom has a script that generates a SQL*Loader control file including the data. I have seen links to it from this forum - do a search.

_____________
Ross Leishman

Report message to a moderator