Replace 456 with your last 3 digits in your student number The procedure must have: an input parameter which has name vehicleId and data type NUMBER. an output parameter which has name rentAmount and NUMBER data type. Assume the rent is 75$ per day Then write PL/SQL code to execute the your stored procedure to calculate the rent for a vehicle ( use any vehicle number except 1 or 2) Sample Output Script Output x 日昌口 Task completed in 0.101 seconds Total Rent for the Vehical Id 1 : 225 PL/SQL procedure successfully completed. 1 2 VEHICLE_ID MANUFACTURER MODELNAME TYPE RENT_DATE RETURN_DATE Car 20-FEB-18 Car 10-MAR-18 1 Honda 2 Hyundai City 120 23-FEB-18 13-MAR-18 Note: Submit the code of your stored procedure and the PL/SQL code that executes it and outputs the result in th screen. Also paste the clear screenshots with outputs. Also
Replace 456 with your last 3 digits in your student number The procedure must have: an input parameter which has name vehicleId and data type NUMBER. an output parameter which has name rentAmount and NUMBER data type. Assume the rent is 75$ per day Then write PL/SQL code to execute the your stored procedure to calculate the rent for a vehicle ( use any vehicle number except 1 or 2) Sample Output Script Output x 日昌口 Task completed in 0.101 seconds Total Rent for the Vehical Id 1 : 225 PL/SQL procedure successfully completed. 1 2 VEHICLE_ID MANUFACTURER MODELNAME TYPE RENT_DATE RETURN_DATE Car 20-FEB-18 Car 10-MAR-18 1 Honda 2 Hyundai City 120 23-FEB-18 13-MAR-18 Note: Submit the code of your stored procedure and the PL/SQL code that executes it and outputs the result in th screen. Also paste the clear screenshots with outputs. Also
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
please use input variable for live sql and explain the code
![Create a stored procedure named - rentCalculation [456]
Replace 456 with your last 3 digits in your student number
The procedure must have:
an input parameter which has name vehicleId and data type NUMBER.
an output parameter which has name rentAmount and NUMBER data type.
Assume the rent is 75$ per day
Then write PL/SQL code to execute the your stored procedure to calculate the rent
for a vehicle ( use any vehicle number except 1 or 2)
Sample Output
Script Output x
89
Task completed in 0.101 seconds
Total Rent for the Vehical Id 1 = 225
PL/SQL procedure successfully completed.
1
2
✩ VEHICLE_ID MANUFACTURER MODELNAME TYPE RENT_DATE RETURN_DATE
Car 20-FEB-18 23-FEB-18
Car 10-MAR-18 13-MAR-18
1 Honda
2 Hyundai
City
120
Note:
Submit the code of your stored procedure and the PL/SQL code that executes it and
outputs the result in th screen. Also paste the clear screenshots with outputs. Also](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ff1f39aa5-4e0b-40b7-807a-db76580272f9%2Fac6ea1c0-5a13-4073-8e40-41e7a7d03b33%2Fqe6anke_processed.png&w=3840&q=75)
Transcribed Image Text:Create a stored procedure named - rentCalculation [456]
Replace 456 with your last 3 digits in your student number
The procedure must have:
an input parameter which has name vehicleId and data type NUMBER.
an output parameter which has name rentAmount and NUMBER data type.
Assume the rent is 75$ per day
Then write PL/SQL code to execute the your stored procedure to calculate the rent
for a vehicle ( use any vehicle number except 1 or 2)
Sample Output
Script Output x
89
Task completed in 0.101 seconds
Total Rent for the Vehical Id 1 = 225
PL/SQL procedure successfully completed.
1
2
✩ VEHICLE_ID MANUFACTURER MODELNAME TYPE RENT_DATE RETURN_DATE
Car 20-FEB-18 23-FEB-18
Car 10-MAR-18 13-MAR-18
1 Honda
2 Hyundai
City
120
Note:
Submit the code of your stored procedure and the PL/SQL code that executes it and
outputs the result in th screen. Also paste the clear screenshots with outputs. Also
Transcribed Image Text:A vehicle is rented on a daily charge basis. Suppose total rent needs to
be calculated based on its rented and return dates, using a procedure.
Table Structure:
CREATE TABLE VEHICLERENT (
VEHICLE_ID NUMBER(8,0) PRIMARY KEY,
MANUFACTURER VARCHAR2(75) NOT NULL,
MODELNAME VARCHAR2(20),
TYPE VARCHAR2(10),
RENT_DATE DATE,
RETURN_DATE DATE);
Enter 5 Records to the above table (here there are 2, but add yourself 3
more):
INSERT INTO VEHICLERENT VALUES(1, 'Honda', 'City',
'Car',TO_DATE('2022-02-20','YYYY-MM-DD'), TO_DATE('2022-02-23','YYYY-MM-
DD'));
INSERT INTO VEHICLERENT VALUES(2, 'Hyundai', 'i20',
'Car',TO_DATE('2022-03-10','YYYY-MM-DD'), TO_DATE('2022-03-13','YYYY-MM-
DD'));
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY