Categories
Uncategorized

Pl/sql query(cIA5)

1. Create a PL/SQL block that selects the maximum department number in the DEPARTMENTS table and stores it in a variable. Print the results to the screen. Solution, declare V_max department.deptno%type; begin select max(deptno) into V_max from department; dbms_Output.put_line(V_max); end; / 3. Write a PL/SQL block which accepts employee name, basic and should displayEmployee name, […]