Generating sql insert into for Oracle

Question

The only thing I don't have an automated tool for when working with Oracle is a program that can create INSERT INTO scripts.

I don't desperately need it so I'm not going to spend money on it. I'm just wondering if there is anything out there that can be used to generate INSERT INTO scripts given an existing database without spending lots of money.

I've searched through Oracle with no luck in finding such a feature.

it exists in PL/SQL Developer, but error for BLOB fields

Thanks in advanced

Answer 1

I didn't work with oracle for some time, but as I remember you can export and import single tables using the exp and imp tools from oracle. You could even specify filters. There might be a replacement for exp and imp meanwhile.

Answer 2

If you have to load a lot of data into tables on a regular basis, check out SQL Loader or external tables. Should be much faster than individual Inserts.

Answer 3

You can also use MyGeneration (free tool) to write your own sql generated scripts. There is a "insert into" script for SQL Server included in MyGeneration, which can be easily changed to run under Oracle.

Answer 4

Oracle's free SQL Developer will do this:

http://www.oracle.com/technology/products/database/sql%5Fdeveloper/index.html

You just find your table, right-click on it and choose Export Data->Insert

This will give you a file with your insert statements. You can also export the data in SQL Loader format as well.

Answer 5

hey mate here is the solution of qoeries for all database stuff ... no matters in whch ur db r... jst chck ot blw link cheers ....

http://www.dpriver.com/pp/sqlformat.htm

Answer 6

You might execute something like this in the database:

select "insert into targettable(field1, field2, ...) values(" || field1 || ", " || field2 || ... || ");"
from targettable;

Something more sophisticated is here.