| insert statements [message #374717] |
Tue, 26 June 2001 07:46  |
Selva
Messages: 15
Registered: June 2001
|
Junior Member |
|
|
Hi,
I have 3 tables named individual, group and group_individual.All tables have one common column named ID.Individual and group tables have datas for the coulmn ID from sequences.In group_individual table the column ID has to have the combination of these both ID values. All other columns in that table must have different datas.How can I write the insert statement.please let me know.
Thank you,
Selva
|
|
|
|
| Re: insert statements [message #374776 is a reply to message #374717] |
Fri, 29 June 2001 22:51  |
Palani
Messages: 8
Registered: June 2001
|
Junior Member |
|
|
Insert into individual
values (IndiSeq.NEXTVAL,....,....,...)
Insert Into Group
values(GrpSeq.NEXTVAL,....,.....,...)
Insert into Individual_Group
values(IndiSeq.LASTVAL||GrpSeq.LASTVAL,....,....,...)
Hope u will get it done.
Palani.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
