Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning Apache Cassandra Development

Authors: Vivek Mishra

1st Edition

1484201426, 9781484201428

More Books

Students also viewed these Databases questions