Question: This assignment will demonstrate the use of transactions. Specifically, changes will be rolled back to a previous state prior to performing a commit. The assignment
This assignment will demonstrate the use of transactions. Specifically, changes will be rolled back to a previous state prior to performing a commit. The assignment will be composed of SQL Plus, DML, and DCL statements. Script that performs the following.
- Login to SQL Plus as user SCOTT
- Issue a statement to display the employee number, employee name and salaryfrom the "emp" table
- Issue a statement to begin a transaction
- Issue statement(s) to insert 4 new records into the "emp" table.
- Issue a statement that repeats Step 2 (to verify that all changes have been added).
- Issue a statement to rollback the changes
- Issue a statement that repeats Step 2( to verify that all changes have been undone)
Save the script as Project13.sql
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
