If you insert a row in a table, then create another table and then say Rollback.In this case will the row be inserted ? Thank you in advance.
asked
Insert a row to a table and create another table then say Rollback. Will the row be inserted ?
According to all the documentation I've read, yes. And that is how it works for me. Any DDL statement does a commit. Any work pending is committed.
Have you tried this and found it does't work as advertised?
Thanks for the answer. Yes..I'm seeing that row is inserted into the table. But the new table is not created.
DDL always implicitly commits. That's why TRUNCATE can't be undone with a ROLLBACK, b/c it's a DDL vs DML statement.
Some tools use separate sessions to issue/execute commands, so it's possible your INSERT and CREATE are happening in different sessions. Tools that are 'threaded' generally work this way. Applications like SQL*Plus wouldn't exhibit that behavior.
In either case, you should commit or rollback a table change as soon as you make up your mind and definitely before you go do maint work in the system - or at least open up another command-window so you have a dedicated session.
