This assignment will demonstrate the use of transactions. Specifically, changes will be rolled back to a previous
Fantastic news! We've Found the answer you've been seeking!
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 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
Related Book For
Complete Business Statistics
ISBN: 9780077239695
7th Edition
Authors: Amir Aczel, Jayavel Sounderpandian
Posted Date: