DML Scripts (like insert commands) for tables

544232

Hi,

Please help me find a solution for the problem.
I have nearly 100 master tables in my database with data.
My requirement is to generate DML script for 'Data' in this master tables.

Client need data of all master tables in DML format.(like insert commands); So they can simply execute it. How do this requirement

How can I do that?

Mark Reichman

This is not an Oracle Forms question for this forum... However,

Do you have tools like...

1) TOAD
2) PLSQL Developer
3) SQL Navigator
4) SQL Developer

Use the export features of these tools.. They will generate the insert scripts that you desire.

...or..

Contact your DBA.. They have tools..

...or..

export and import

http://www-it.desy.de/systems/services/databases/oracle/impexp/impexp.html.en

544232

Actually i am developing a form application which display all tables of the database on form and when i check on any table it will create a DML Script (like insert commands) for the table if any utility exist in oracle plz share with me.

thanks.

user346369

Well... it is time to plug my old QA utility form:

<P>QA inserts, updates and displays data in practically any Oracle table. It runs in Forms 6i and on the web in 10g.

<P>Source code is available if you need it.

<P>QA: Quick Access Form

Edited by: Steve Cosner on Nov 14, 2008 9:42 PM -- website changed

122352

Hi,

I am using two ways:

- Oracles SQL Developer (right click on the data grid & create insert script)

- http://www.oracle-base.com/dba/script_creation/create_data.sql

Hope it helps,
Friedhold