how to create an insert script from a table using TOAD, oracle?

Question

I used TOAD for oracle 11g, I want to create an insert script from a table. or I want to create a script file that allows eclipse to rebuild the entire database with their data.

Answer 1

Run your query Ex: Select * from employee;

In the table result grid > Click on 'Export grid Contents' icon (Marked in yellow in the above image)

Select Export Format as 'Insert Statements' > Click OK

You are done!

Answer 2

the solution is :

data base > schema browser

then I select a table in :

> my schema > tables > my_table

to export the script to allow you to create your table :

script > (copy past the create table part)

to export alla data :

>data > export dataset (blue icone) > export format : insert statement (and specify the output file)

then you can regroup the two script in a single script.sql (in order)