Re: How to dump table contents as SQL statements?

No, Oracle does not have any built-in functionality for this.

My tool SQL PlusPlus (freeware) allows you to do so with its BLDISC (Built INSERT script) command.

It is as simple as executing the following in your SQL Plus:

SQL> EXEC S2.BLDISC('DEPT','SCOTT') And it will dump out the script as per your requirements.

Enjoy,

regards,
M. Armaghan Saqib

• SQL PlusPlus: Add power to SQL Plus.
• SQL Link for XL: Integrate Oracle with XL.
• Oracle CBT with sample GL (Triggers and Forms Source Code included. Download free: http://www.geocities.com/armaghan/

  ---

In article <86lj8r$ck8$1_at_agate.berkeley.edu>,   gopal_at_bisc.EECS.Berkeley.EDU (Gopal Santhanam) wrote:
>
> Hi,
>
> How do you dump the data contents of a table as a series of sql insert
> statements? I'd like to generate a sql script file that can be later
> loaded into an empty incarnation of the same table.
>
> I know there is such an animal in for MySQL.
>
> Gopal
>

--


Sent via Deja.com http://www.deja.com/
Before you buy.