Output in Oracle

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