Question: Using a cursor and for loop, display the department_ID, department_name, first_name, last_name, job_id, salary, of all the employees, who are working as IT_Prog (Job_ID) and

Using a cursor and for loop, display the department_ID, department_name, first_name, last_name, job_id, salary, of all the employees, who are working as IT_Prog (Job_ID) and earning more than 1500.

Step by Step Solution

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

Students Have Also Explored These Related Databases Questions!

2. For this exercise, you use the employees and departments table. Create a PL/SQL block that fetches and displays the names of the five departments with the most employees (Hint: use a join...

CREATE TABLE LOCATIONS( LOCATION_ID NUMBER(4) PRIMARY KEY NOT NULL, STREET_ADDRESS VARCHAR(20), POSTAL_CODE VARCHAR(10), CITY VARCHAR(15) NOT NULL, STATE_PROVINCE VARCHAR(10), COUNTRY_ID CHAR(2));...

2. For this exercise, you use the employees and departments table. Create a PL/SQL block that fetches and displays the names of the five departments with the most employees (Hint: use a join...

Use the tables in your schema. 1) Write a query that produces the following for each employee whose last name begins with an R: earns monthly but wants . Use a function to format the salary with a...

Urgently needed COUNTRIES (COUNTRY_ID, COUNTRY_NAME, REGION_ID) Primary Key: COUNTRY_ID DEPARTMENTS (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID): Primary key. DEPARTMENT_ID EMPLOYEES (...

DATABASE PROGRAMMING - WRITE THE SQL QUERIES FOR THE FOLLOWING QUESTIONS CREATE TABLE dept ( deptno NUMBER(2,0), dname VARCHAR2(14), loc VARCHAR2(13), CONSTRAINT n_pk_dept PRIMARY KEY (deptno) );...

WRITE SQL QUERIES FOR THE FOLLOWING QUESTIONS WHICH IS BASED ON EMPLOYEES TABLE Below is a sample of searched CASE statement. It finds the average salary of the employees in the Employees table,...

Write an anonymous PL/SQL block. Define an Associative Array type called Email_Phone. That Associative Array will use employees emails (its data type is varchar2 (25), you may get this via command...

CREATE TABLE LOCATIONS( LOCATION_ID NUMBER(4) PRIMARY KEY NOT NULL, STREET_ADDRESS VARCHAR(20), POSTAL_CODE VARCHAR(10), CITY VARCHAR(15) NOT NULL, STATE_PROVINCE VARCHAR(10), COUNTRY_ID CHAR(2));...

For an investment of 10x 106 $ with an annual interest rate of 140% for five years, 1-) Annual Case: Assuming compound interest, what will be the amount of money repaid at the end of five years? 2-)...

How many taxpayers do you think follow the gross income rules for treasures and finds? Do you agree with the federal governments application of tax laws related to treasures and finds? Explain your...

17. You are the manager of a firm that competes against four other firms by bidding for government contracts. While you believe your product is better than the competitions, the government purchasing...

Your uncle has a fish ball stall in Mongkok and its business has been very good since it started three years ago. Although the business is making a profit, there is an inventory problem that has been...

1-9 In this project, you will start out with raw transactional sales data and use Microsoft Access database software to develop queries and reports that help managers make better decisions about...

1-11 In MyMISLab, you will find a Collaboration and Teamwork Project dealing with the concepts in this chapter. You will be able to use Google Drive, Google Docs, Google Sites, Google+, or other...

1-12 What kinds of applications are described in this case? What business functions do they support? Mashaweer is the first personal service company in Egypt. Its purely dedicated to saving its...