Categories
Uncategorized

PL/SQL Query

1. Create Pl/Sql block to delete the department created. print to the scree the number of rows affected.   set serveroutput on; declare V_count number(3); begin select count(*) into v_count from employee where deptno=(select max(deptno) from department); delete from employee where deptno=(select max(deptno) from department); dbms_output.put_line(‘no of rows deleted:’||V_count); end; / 2.  Write a PL/SQL […]