Originally posted by engiri
Regarding the insert command .. generating..

You have to write a procedure..

step 1:Cursor selects the tables of that schema
Loop starting
Step 2:Cursor selects the number of columns in the table.
Loop
step 2: For The number of columns generate the required
columns selection command .
step 3: accumulate the selection columns into a variable.
Need to add '' if the field is of type char
step 4: add to the insert into command with that table name

Use Dba_tab_columns to find the column list of a table

regards
giri
Can do without cursors.

Abhay.