Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
10:45 Done Practical Excercise 5 (9... Enter 5 Records to the above table INSERT INTO VEHICLERENT VALUES(1, "Honda', 'City', 'Car',TO_DATE('2018-02- 20','YYYY-MM-DD'), TO DATE(2018-02-23", "YYYY-MM-DD')); Create a stored procedure is named - rentCalculation [456] Replace 456 with your last 3 digits in your student number It has: :!!! LTE INSERT INTO VEHICLERENT VALUES(2, 'Hyundai', 'i20', 'Car',TO_DATE('2018-03- 10', 'YYYY-MM-DD'), TO_DATE(2018-03-13','YYYY-MM-DD')); a an input parameter which has name vehicleld and data type NUMBER. an output parameter which is named rentAmount and NUMBER data type. Assume the rent is 75$ per day Sample Output Execute the Stored Procedure to calculate the rent for a vehicle ( use any vehicle number except 1 or 2) Script Output x

10:45 Done Practical Excercise 5 (9... Enter 5 Records to the above table INSERT INTO VEHICLERENT VALUES(1, "Honda', 'City', 'Car',TO_DATE('2018-02- 20','YYYY-MM-DD'), TO DATE(2018-02-23", "YYYY-MM-DD')); Create a stored procedure is named - rentCalculation [456] Replace 456 with your last 3 digits in your student number It has: :!!! LTE INSERT INTO VEHICLERENT VALUES(2, 'Hyundai', 'i20', 'Car',TO_DATE('2018-03- 10', 'YYYY-MM-DD'), TO_DATE(2018-03-13','YYYY-MM-DD')); a an input parameter which has name vehicleld and data type NUMBER. an output parameter which is named rentAmount and NUMBER data type. Assume the rent is 75$ per day Sample Output Execute the Stored Procedure to calculate the rent for a vehicle ( use any vehicle number except 1 or 2) Script Output x

Computer Networking: A Top-Down Approach (7th Edition)
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...
See similar textbooks
icon
Related questions
Question
Database programming
10:45 Done Practical Excercise 5 (9... A Enter 5 Records to the above table INSERT INTO VEHICLERENT VALUES(1, "Honda', 'City', 'Car,TO_DATE('2018-02- 20', 'YYYY-MM-DD'), TO_DATE('2018-02-23','YYYY-MM-DD')); INSERT INTO VEHICLERENT VALUES(2, 'Hyundai', 'i20', 'Car',TO_DATE('2018-03- 10', 'YYYY-MM-DD'), TO_DATE(2018-03-13', YYYY-MM-DD')); Create a stored procedure is named - rentCalculation [456] Replace 456 with your 3 digits in your stud t number It has: an input parameter which has name vehicleld and data type NUMBER. an output parameter which is named rentAmount and NUMBER data type. Assume the rent is 75$ per day Execute the Stored Procedure to calculate the rent for a vehicle ( use any vehicle number except 1 or 2) Sample Output Script Output x 83 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 1 Bonda 2 Hyundai RENT_DATERETURN_DATE Car 20-FEB-18 23-FEB-18 Car 10-MAR-18 13-MAR-18 City 120 LTE Note: Paste the clear screenshots with outputs and code Explain the code block briefly FILE NAME: Practical Exercise5YourFirstName (like Practical Exercise5Abu(Doc/Pdf)) :=
Transcribed Image Text:10:45 Done Practical Excercise 5 (9... A Enter 5 Records to the above table INSERT INTO VEHICLERENT VALUES(1, "Honda', 'City', 'Car,TO_DATE('2018-02- 20', 'YYYY-MM-DD'), TO_DATE('2018-02-23','YYYY-MM-DD')); INSERT INTO VEHICLERENT VALUES(2, 'Hyundai', 'i20', 'Car',TO_DATE('2018-03- 10', 'YYYY-MM-DD'), TO_DATE(2018-03-13', YYYY-MM-DD')); Create a stored procedure is named - rentCalculation [456] Replace 456 with your 3 digits in your stud t number It has: an input parameter which has name vehicleld and data type NUMBER. an output parameter which is named rentAmount and NUMBER data type. Assume the rent is 75$ per day Execute the Stored Procedure to calculate the rent for a vehicle ( use any vehicle number except 1 or 2) Sample Output Script Output x 83 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 1 Bonda 2 Hyundai RENT_DATERETURN_DATE Car 20-FEB-18 23-FEB-18 Car 10-MAR-18 13-MAR-18 City 120 LTE Note: Paste the clear screenshots with outputs and code Explain the code block briefly FILE NAME: Practical Exercise5YourFirstName (like Practical Exercise5Abu(Doc/Pdf)) :=
10:45 Done Practical Excercise 5 (9... A CSAM - Database Programming -CSD 4203 Database Programming: Practical Exercise #5 Term: 2022S Student Name: Student Number: A vehicle is rented on a daily charge basis. Suppose total rent needs to be calculated based on its rented and return dates using procedure. Table Structure: CREATE VEHICLERE "( 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 Q INSERT INTO VEHICLERENT VALUES(1, "Honda', 'City', 'Car',TO_DATE('2018-02- 20','YYYY-MM-DD'), TO_DATE('2018-02-23', 'YYYY-MM-DD')); INSERT INTO VEHICLERENT VALUES(2, 'Hyundai', 'i20', 'Car',TO_DATE('2018-03- 10', 'YYYY-MM-DD'), TO_DATE('2018-03-13','YYYY-MM-DD')); Create a stored procedure is named - rentCalculation [456] Replace 456 with your last 3 digits in your student number It has: LTE an input parameter which has name vehicleld and data type NUMBER. an output parameter which is named rentAmount and NUMBER data type. Assume the rent is 75$ per day Execute the Stored Procedure to calculate the rent for a vehicle ( use any |||
Transcribed Image Text:10:45 Done Practical Excercise 5 (9... A CSAM - Database Programming -CSD 4203 Database Programming: Practical Exercise #5 Term: 2022S Student Name: Student Number: A vehicle is rented on a daily charge basis. Suppose total rent needs to be calculated based on its rented and return dates using procedure. Table Structure: CREATE VEHICLERE "( 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 Q INSERT INTO VEHICLERENT VALUES(1, "Honda', 'City', 'Car',TO_DATE('2018-02- 20','YYYY-MM-DD'), TO_DATE('2018-02-23', 'YYYY-MM-DD')); INSERT INTO VEHICLERENT VALUES(2, 'Hyundai', 'i20', 'Car',TO_DATE('2018-03- 10', 'YYYY-MM-DD'), TO_DATE('2018-03-13','YYYY-MM-DD')); Create a stored procedure is named - rentCalculation [456] Replace 456 with your last 3 digits in your student number It has: LTE an input parameter which has name vehicleld and data type NUMBER. an output parameter which is named rentAmount and NUMBER data type. Assume the rent is 75$ per day Execute the Stored Procedure to calculate the rent for a vehicle ( use any |||
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
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 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)
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
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS