Instruction : Create a new database and insert data where necessary 1.Write a PL/SQL code to display
Fantastic news! We've Found the answer you've been seeking!
Question:
Instruction : Create a new database and insert data where necessary
1.Write a PL/SQL code to display the empno, ename, job of employees of department number 10 with CURSOR FOR Loop statement.
2.Write a PL/SQL code to display the empno, ename, job of employees of department number 10 for EMP table (empno, ename, job, sal, deptno)
3.Write a PL/SQL code of a local procedure that accepts two numbers and return its addition, subtraction, multiplication and division
Expert Answer:
Related Book For 
Posted Date:
