PL/SQL

solve practice 1.2 , 1.3 and 1.4 only. Using PL/SQL oracle

Practice:: 1.2 Print all the information of department 20 1.3 Print all the information of department 20 using cursor with for loop and you must open the cursor implicity. 1.4 Print the third row Exercise-1 Create a table Employee', which contains the following records. EMP_NO EMP DEPT EMP_SALARY 1 2 EMP_NAME John Steve marks Spencer Julia Robert Demi Moore Web Developer Program Developer Program Developer Web Developer 45000 38000 34000 42000 3 4 1.1 Add new column "DEPT_No" as following: EMP_NO DEPT_NO 1 10 2 20 3 20 4 20 Practice:: 1.2 Print all the information of department 20 1.3 Print all the information of department 20 using cursor with for loop and you must open the cursor implicity. 1.4 Print the third row