Oracle: insert a row & create another table.

Question

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

Answer 1

A package cursor is a cursor which you declare in the package specification without an SQL statement. The SQL statement for the cursor is attached dynamically at runtime from calling procedures.