Home » Developer & Programmer » JDeveloper, Java & XML » insert for two tables.Master-Detail
insert for two tables.Master-Detail [message #91153] Fri, 10 May 2002 09:02 Go to next message
swapna
Messages: 11
Registered: May 2002
Junior Member
I want to post data in two tables.Having master-deatil relationship.The records should be posted into second table using the sequence number of the record which was inserted in to the first table. Any help?

Report message to a moderator

Re: insert for two tables.Master-Detail [message #91210 is a reply to message #91153] Wed, 29 May 2002 14:52 Go to previous messageGo to next message
jstu
Messages: 1
Registered: May 2002
Junior Member
You can create a sequence in the oracle db, do a select on the sequence to get the sequence number and insert that sequence number into the master and detail table.

Report message to a moderator

Re: insert for two tables.Master-Detail [message #91287 is a reply to message #91210] Tue, 02 July 2002 18:49 Go to previous message
HENDERSON ESTRADA
Messages: 1
Registered: July 2002
Junior Member
I NEED YOUR HELP!

Report message to a moderator

Previous Topic: manipulating oracle dates with java?
Next Topic: RE: Oracle ORA-00911 Invalid Character
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 05:55:56 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.