Use of inserted data that has not been committed
Posted on 2013-05-22
I have multiple inserts and will not commit until all inserts are successful.
One of the table's values depends upon data in one of the table' s insert that has not been committed..
Is that data available in the table to use?
For example I need to use one of the table's primary key as a foreign key in another table whose data is being inserted.
Insert into table a value(primary key, name
I need to insert tablea primary key into tableb as a foreign key before table a insert has been committed.
Insert into table b (tablea.primary key, nameb