Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Distributed and object database Employee Empno Ename Job NGRI Hiredate | Sal |Comm) DeptNo 7839King President 7698 Blake 7782 IClark 7566 Johns M 02-Apr-81 7654
Distributed and object database
Employee Empno Ename Job NGRI Hiredate | Sal |Comm) DeptNo 7839King President 7698 Blake 7782 IClark 7566 Johns M 02-Apr-81 7654 Martin Salesman 7698 28-S 7499 Allen Salesman 7698 20-Feb-81 16 7844 Turner Salesman 7698 108-S 7900 James Clerk 7521 7902 Ford 7369 Smith Clerk 7788 Sct Anal 7876 Adams Clerk 7934 Miller Clerk 17-Nov-81 10 30 Manager 7839 01-May-81 2850 Manager 783909-Jun-812450 Manager 7839 20 30 8112 7698 03-Dec-81 950 rd Salesmanl 7698 22-Feb-81125 7566 03-Dec-81 7902 17-Dec-80 800 7566 09-Dec-8230 7788 12-Jan-83 1100 7782 23-Jan-8213 20 20 20 Department DeptNo Dname Location 10 20 30 Accountin Research Sharaiah Sales man Abu Dhabi Dubai . Create a PL/SQL block to declare a cursor EMP CUR to select the employee name, salary, and hire date from the EMPLOYEES table. Process each row from the cursor, and if the salary is greater than 2,000 and the hire date is greater than 01-FEB-1981, display the employee name, salary, and hire date in the screen Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started