Insert Set

Insert Set
How to Insert to Multiple Tables in Oracle SQL at runtime? The first table sets the primary key.?

I am inserting to Table 1 (which sets the primary key - generated by a sequence) and also to Table 2 which references the primary key in Table 1 as a foreign key.

Is there a way to reference the Table 1 primary key as a foreign key in the Table 2 insertion? Thanks.

try using two inserts as part of single transaction block:

SET TRANSACTION NAME 'DoubleInsert';
insert into table1(pk,...) values (mySequence.nextVal,...);
insert into table2(fk,....) values(mySequence.curVal,...);
COMMIT;

or without transactions, fetch first sequence into temporary variable and then execute two inserts using the stored value.

Check out the Insert Set listings below and save 20% to 70% off retail prices:

 

---

 

How to set up a PA System - and use Insert Cables


 

---

 



 

---

 
The Video Encoding Guide: Codecs, Formats, Containers And Settings Explained
Video encoding is the science of codifying the bits of data that make up a digital video recording into a unified whole according to a set of specific standards and parameters. If it sounds techy, it should. In simpler words, video encoding is the process of taking your original movie, as recorded by your camcorder, mobile phone or webcam, and preparing it for delivery in a digital format ...