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!

commit a specific table only and a question on simple dml trigger

Mac_Freak_RahulJan 26 2011 — edited Jan 30 2011

Hi all,

supose i logged onto a database with the user 'scott'/'tiger'@orcl and i fire insert statements on 2 different tables lets say tables are
1) emp
2) dept

and now only I want to commit the emp table and not the dept table , is there a way to do that?

One more question I have .. are simple dml triggers auto commit or not?

Regards
Rahul

This post has been answered by 736193 on Jan 26 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 27 2011

Added on Jan 26 2011

5 comments

1,446 views