Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions Icon

Related questions

bartleby

Concept explainers

Question
100%

scrip for table is provided 

1
2
3.
4
5
6
7
8
9
10
11
12
13
14
15
16
17
-- EMPLOYEES table
CREATE TABLE employees
e employee_id
NUMERIC (3) NOT NULL,
first_name
VARCHAR(20)
3
middle_initial VARCHAR(1)
3
last_name
VARCHAR(30) 3
soc_sec_no
NUMERIC (9)
A
hire_date
DATE
salary
DECIMAL (7,2),
commission_pct DECIMAL (3,3),
department_code VARCHAR(2) 3
job_code
VARCHAR(7),
manager_id
NUMERIC (3)
);
expand button
Transcribed Image Text:1 2 3. 4 5 6 7 8 9 10 11 12 13 14 15 16 17 -- EMPLOYEES table CREATE TABLE employees e employee_id NUMERIC (3) NOT NULL, first_name VARCHAR(20) 3 middle_initial VARCHAR(1) 3 last_name VARCHAR(30) 3 soc_sec_no NUMERIC (9) A hire_date DATE salary DECIMAL (7,2), commission_pct DECIMAL (3,3), department_code VARCHAR(2) 3 job_code VARCHAR(7), manager_id NUMERIC (3) );
Write a complete PL/SQL Cursor to retrieve the following information.
Fetch row number, Employee Id, First Name of the employees
Select all the employees with Employee_no < 115
Use the complete cycle of declaring, opening, fetching, and closing a cursor,
including use of cursor attributes.
Format the output as shown below
Script Output x
Task completed in 0.299 seconds
Just FETCHED row 1- Employee ID: 110 - First Name: Lauren
Just FETCHED row 2- Employee ID: 111 - First Name: Lisa
Just FETCHED row 3- Employee ID: 112 - First Name: Dave
Just FETCHED row 4- Employee ID: 113 - First Name: Steve
Just FETCHED row 5- Employee ID: 114 - First Name: Marg
(b)
Modify your program to use the CURSOR FOR LOOP to achieve the same output
Script Output x
Task completed in 0.175 seconds
Just FETCHED row 1- Student ID: 110 - First Name Lauren
Just FETCHED row 2- Student ID: 111 - First Name Lisa
Just FETCHED row 3- Student ID: 112 - First Name Dave
Just FETCHED row 4- Student ID: 113 - First Name Steve
Just FETCHED row 5- Student ID: 114 - First Name Marg
expand button
Transcribed Image Text:Write a complete PL/SQL Cursor to retrieve the following information. Fetch row number, Employee Id, First Name of the employees Select all the employees with Employee_no < 115 Use the complete cycle of declaring, opening, fetching, and closing a cursor, including use of cursor attributes. Format the output as shown below Script Output x Task completed in 0.299 seconds Just FETCHED row 1- Employee ID: 110 - First Name: Lauren Just FETCHED row 2- Employee ID: 111 - First Name: Lisa Just FETCHED row 3- Employee ID: 112 - First Name: Dave Just FETCHED row 4- Employee ID: 113 - First Name: Steve Just FETCHED row 5- Employee ID: 114 - First Name: Marg (b) Modify your program to use the CURSOR FOR LOOP to achieve the same output Script Output x Task completed in 0.175 seconds Just FETCHED row 1- Student ID: 110 - First Name Lauren Just FETCHED row 2- Student ID: 111 - First Name Lisa Just FETCHED row 3- Student ID: 112 - First Name Dave Just FETCHED row 4- Student ID: 113 - First Name Steve Just FETCHED row 5- Student ID: 114 - First Name Marg
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Computer Science
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.
Similar questions
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education