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!

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,396 views