Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PRIMARY KEY ... DEFERRABLE INITIALLY....

733971Nov 27 2009 — edited Nov 27 2009
Hi... I've some doubts about "DEFERRABLE INITIALLY IMMEDIATE" and "DEFERRABLE INITIALLY DEFERRED"

I think I ve understood the difference, but im not sure... So i write an example for having confirmation....


PRIMARY KEY (key) DEFERRABLE INITIALLY IMMEDIATE.. this is the default.... It means:
1. I insert a new row in the table;
2. It check if i can insert those row.
3. It does the COMMIT.








PRIMARY KEY (key) DEFERRABLE INITIALLY DEFERRED means:
1. I insert a ne row in the table;
2. I do the COMMIT;
3. It check if I can insert thos row.


That's correct?


thanks
This post has been answered by Karthick2003 on Nov 27 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 25 2009
Added on Nov 27 2009
2 comments
10,966 views