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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

63626e024d695_236545.pdf

180 KBs PDF File

Word file Icon

63626e024d695_236545.docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!