Home » RDBMS Server » Server Administration » Saving into two tables
Saving into two tables [message #370623] Tue, 11 January 2000 07:27 Go to next message
josef cihal
Messages: 12
Registered: January 2000
Junior Member
Please help!
I need to save at one time in one form into two tables.
Need I to create master-detail relation or something others???
Thanks.
Regard
josef
Re: Saving into two tables [message #370626 is a reply to message #370623] Tue, 11 January 2000 14:46 Go to previous messageGo to next message
MikeG
Messages: 14
Registered: August 1999
Junior Member
I believe that you need to understand the concept of a transaction. You can begin a transaction, insert into both tables and then either commit or rollback. by including both inserts in the same transaction they are a logical block and are either committed/rolled back together.
Re: Saving into two tables [message #370632 is a reply to message #370626] Wed, 12 January 2000 03:12 Go to previous message
josef cihal
Messages: 12
Registered: January 2000
Junior Member
Mike,
O.K>.
I understand now , how it works. Can you help me please,...
Need I to write script for example:
..insert into table ...values...
or I need simply to define master -detail relation, between 3 blocks. Two tables (A and B)are binded with one asociation table(C) (these table(C) include two primary keys from tables A and B).
Thanks.
Regard
josef cihal
Previous Topic: Re: Newbie - '&' in PL/SQL
Next Topic: Simultaneous select and update while row-locking?
Goto Forum:
  


Current Time: Sat Oct 31 20:50:55 CDT 2020