Please send your Questions & Answers or Feedback to "mohan@javabook.org"

If you insert a row in a table, then create another table and then say Rollback. In this case will the row be inserted ?

Yes. Because Create table is a DDL which commits automatically as soon as it is executed. The DDL commits the transaction even if the create statement fails internally (eg table already exists error) and not syntactically.

Related Posts Plugin for WordPress, Blogger...
Flag Counter