regd database [message #20144] |
Wed, 01 May 2002 09:21 |
Sirisha
Messages: 7 Registered: May 2002
|
Junior Member |
|
|
if we want to insert 14 fields of information in to 14 different tables is it possible?, how it can be done.
|
|
|
Re: regd database [message #20146 is a reply to message #20144] |
Wed, 01 May 2002 10:49 |
oraboy
Messages: 97 Registered: October 2001
|
Member |
|
|
Insert All
into table1(col1) values (col1)
into table2(col1) values (col2)
....
into table14(colname) values (col14)
Select col1,col2,col3..col14 from source_table;
This MULTI TABLE INSERT is a new feature of 9i
Oraboy
|
|
|