Skip to Main Content

SQL Developer

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Is commit necessary after DML operation on table using simple sql query?

simyogAug 12 2014 — edited Aug 14 2014

I have confusion about COMMIT command. Is it compulsary to run COMMIT command after DML operation in Sql Developer.

Because i was done with an UPDATE query..

UPDATE TAB1

SET TBX_TYP='ZX'

WHERE TBX_TYP IN(SELECT TBX_TYP

                                  FROM(SELECT DISTINCT TBX_TYP

                                               FROM TAB1 ORDER BY 1 )

                                 WHERE ROWNUM=1);

and when i did filtering on columns then i found nothing was updated. Please suggest.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 11 2014
Added on Aug 12 2014
4 comments
4,200 views