Question

Create a PL/SQL procedure that take deptno
as input from user & print no. of employees
working in that department in same variable.

Answer 1

Explanation:

Write a program in PL/SQL to show the uses of static PL/SQL statement.

Click me to see the solution

2. Write a program in PL/SQL to show the uses of CURVAL and NEXTVAL with a sequence name.

Click me to see the solution

3. Write a program in PL/SQL to find the number of rows effected by the use of SQL%ROWCOUNT attributes of an implicit cursor