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. Write a script that performs the following.

1. Login to SQL Plus as user SCOTT
2. Issue a statement to display the employee number, employee name and salary from the "emp" table
3. Issue a statement to begin a transaction
4. Issue statement(s) to insert 4 new records into the "emp" table.
5. Issue a statement that repeats Step 2 (to verify that all changes have been added).
6. Issue a statement to rollback the changes
7. Issue a statement that repeats Step 2 ( to verify that all changes have been undone)

Notes:

1. The Oracle Universal Installer (OUI) creates the EMP, DEPT, .BONUS, SALGRADE, CUSTOMER, ORD, ITEM, and PRODUCT.

2. The following query will display all tables defined in a user's schema.

SELECT table_name FROM user_tables;

3. The EMP table has a FK constraint on the DEPTNO field (i.e. that value must exist in the DEPT table)