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
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
Step by Step Solution
3.37 Rating (156 Votes )
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Document Format (2 attachments)
63626e024d695_236545.pdf
180 KBs PDF File
63626e024d695_236545.docx
120 KBs Word File
