Output in Oracle

enrollment number in Q2 is 007

1. Create a view which displays the ename, dname and sal of all the employees of deptno 30. Create a PL/SQL program to display highest salary using view created. 2. Create a table My_emp1001 (instead of 1001 write last 3 digits of your enrollment no.) having records of deptno = 30 now Create a view MY_View based on the table My_emp1001 . Now select all the records from the view MY_View. 3. Create a new table which is the replica of EMP table without records. Now write a trigger on EMP table so that whenever any DML (only for INSERT and UPDATE) operation is performed on EMP, original record of the EMP table must be maintained in the new table before getting changed in it