Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
First create a query for cursor..  cursor  cur1   as SELECT e.first_name, e.last_name, e.salary, e.job_id, j.min_salary, j.max_salary From employees e  JOIN jobs j ON xxxx =yyyy In this SQL you will be able to get every employee information and their job_id and for each job_id’s min and max_salary range   Sample result   Steven King  12000  AD_VP        10,000  18,000 Jason Strace 8000   ST_CLERK   4,000   10,000 … ….   In the BEGIN and END section    Use CURSOR for LOOP to go thru all the cursor records…   Use IF THEN ELSE section to check if that line of employee salary is below the half mark or above the half mark? And Print this accordingly

First create a query for cursor..  cursor  cur1   as SELECT e.first_name, e.last_name, e.salary, e.job_id, j.min_salary, j.max_salary From employees e  JOIN jobs j ON xxxx =yyyy In this SQL you will be able to get every employee information and their job_id and for each job_id’s min and max_salary range   Sample result   Steven King  12000  AD_VP        10,000  18,000 Jason Strace 8000   ST_CLERK   4,000   10,000 … ….   In the BEGIN and END section    Use CURSOR for LOOP to go thru all the cursor records…   Use IF THEN ELSE section to check if that line of employee salary is below the half mark or above the half mark? And Print this accordingly

Database Systems: Design, Implementation, & Management
Database Systems: Design, Implementation, & Management
11th Edition
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Chapter7: Introduction To Structured Query Language (sql)
Section: Chapter Questions
Problem 25P
See similar textbooks
icon
Related questions
Question

in sql developer. 

 

First create a query for cursor.. 

cursor  cur1   as

SELECT e.first_name, e.last_name, e.salary, e.job_id, j.min_salary, j.max_salary

From employees e  JOIN jobs j

ON xxxx =yyyy

In this SQL you will be able to get every employee information and their job_id and for each job_id’s min and max_salary range

 

Sample result

 

Steven King  12000  AD_VP        10,000  18,000

Jason Strace 8000   ST_CLERK   4,000   10,000

…

….

 

In the BEGIN and END section 

 

Use CURSOR for LOOP to go thru all the cursor records…

 

Use IF THEN ELSE section to check if that line of employee salary is below the half mark or above the half mark? And Print this accordingly

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
SQL Query
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
SEE MORE TEXTBOOKS