This assignment will demonstrate the use of the Flashback Query Feature. Specifically, information related to the previous state of a table will be displayed.

Write a script, Project3.sql, that performs the following.

Login to SQL Plus as user SCOTT

Issue a statement to display the employee number, employee name, and salary from the "emp" table .

Issue a statement to delete all records with employee number in the range of 7500 - 7800 from the "emp" table.

Issue a statement that repeats Step 2.

Issue a statement to perform a query on the emp table based on its state 5 minutes previous.

Issue a ROLLBACK statement to undo the transaction.

EMP TABLE

EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10), JOB VARCHAR2(9), MGR NUMBER(4) CONSTRAINT EMP_MGR_FK REFERENCES EMP (EMPNO), HIREDATE DATE, SAL NUMBER(7,2), COMM NUMBER(7,2), DEPTNO NUMBER(2) NOT NULL, CONSTRAINT EMP_DEPTNO_FK FOREIGN KEY (DEPTNO) REFERENCES DEPT (DEPTNO), CONSTRAINT EMP_EMPNO_PK PRIMARY KEY (EMPNO));