Trying to understand this quiz question on INSERT



  • Why will there be 2 rows and not 1? The rollback is meant to take it back to the last COMMIT function which in this case is inputted after one INSERT

    enter image description here



  • https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/COMMIT.html

    Oracle Database issues an implicit COMMIT under the following circumstances:

    • Before any syntactically valid data definition language (DDL) statement, even if the statement results in an error

    • After any data definition language (DDL) statement that completes without an error




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2