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 numberThe 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 dayThen write PL/SQL code to execute the your stored procedure to calculate the rentfor a vehicle ( use any vehicle number except 1 or 2)Sample OutputScript Output x89Task completed in 0.101 secondsTotal Rent for the Vehical Id 1 = 225PL/SQL procedure successfully completed.12✩ VEHICLE_ID MANUFACTURER MODELNAME TYPE RENT_DATE RETURN_DATECar 20-FEB-18 23-FEB-18Car 10-MAR-18 13-MAR-181 Honda2 HyundaiCity120Note:Submit the code of your stored procedure and the PL/SQL code that executes it andoutputs the result in th screen. Also paste the clear screenshots with outputs. Also A vehicle is rented on a daily charge basis. Suppose total rent needs tobe 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 3more):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'));

Code is given below. drop table VECHICLERENT; CREATE TABLE VECHICLERENT ( VEHICLE_ID…

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...

See similar textbooks

Similar questions

PL/SQL please use oracle sql developer. I know it would be hard to slove without the data but please help Given a start and end date, print out names, phone number, status, and flight ID of people who were on the same flight with someone whose status is 1 (tested positive) and the flight date is between the start and end date.
I need help with this SQL query: Write a MySQL statement to create a table named jobs including columns job_id, job_title, min_salary and max_salary, and check whether the min_salary amount is lower than the lower limit $15,000 and whether the max_salary amount exceeds the upper limit $50,000.
Create a new table, EMP_PROMOTION to store the employees information. You must use a subquery to create the new table. Make the salary column invisible. Display the structure of the table in SQL Developer. Also use a SELECT statement to display all records from the new table EMP_PROMOTION.
Q. Please write SQL codes to query data from member tables based on below criteria Please write a SELECT statement to display each member’sdata that member_id is an odd number. Please display the result in ascending order of the last_name. The result should be identical to below results: [Screenshot]
What is an index in SQL? Also write it's syntax.
Create a table named company with these columns: Company_id varchar(255) Company_name varchar(255) default ‘x’ Hq_phone_number varchar(255) Primary key of company_id (please use constraint format) Unique key of Hq_phone_number (please use constraint format)
Describe the process of creating a table in SQL and the different data types you can use for fields.
using the link below, select which data type best fits the following needs: https://www.w3schools.com/sql/sql_datatypes.asp The Date a student enrolls with a university The students phone number The name of a degree program The students financial aid amount
Q1. Create a stored procedure that will list all customers (name and number) represented by rep 15. (SQL)
PLZ help with the following using ORACLE command sql Use subqueries CREATE TABLE MEMBERSHIP ( MEM_NUM CHAR(3) CONSTRAINT MEMBER_MEM_NUM_PK PRIMARY KEY, MEM_FNAME VARCHAR(30) NOT NULL, MEM_LNAME VARCHAR(30) NOT NULL, MEM_STREET VARCHAR(15), MEM_CITY VARCHAR(10), MEM_STATE CHAR(2), MEM_ZIP CHAR(5), MEM_BALANCE NUMBER (2)); CREATE TABLE RENTAL ( RENT_NUM CHAR(4) CONSTRAINT RENTAL_RENT_NUM_PK PRIMARY KEY, RENT_DATE DATE, MEM_NUM CHAR(3), CONSTRAINT RENTAL_MEM_NUM_FK FOREIGN KEY (MEM_NUM) REFERENCES MEMBERSHIP); CREATE TABLE PRICE (PRICE_CODE CHAR(1) CONSTRAINT PRICE_PRICE_CODE_PK PRIMARY KEY, PRICE_DESC VARCHAR(20), PRICE_RENTFEE NUMBER (3,1), PRICE_DAILYATFEE NUMBER(3,1)); CREATE TABLE MOVIE (MOVIE_NUM CHAR(4) CONSTRAINT MOVIE_MOVIE_NUM_PK PRIMARY KEY, MOVIE_NAME VARCHAR(30) NOT NULL, MOVIE_YEAR CHAR(4), MOVIE_COST NUMBER(5,2), MOVIE_GENRE VARCHAR(15), PRICE_CODE CHAR(1), CONSTRAINT MOVIE_PRICE_CODE_FK FOREIGN KEY (PRICE_CODE) REFERENCES PRICE); CREATE TABLE VIDEO…
PLZ hlp with the following: In SQL If you add the PRIMARY KEY constraint to a column, you must also add a UNIQUE constraint to it. Select one: True False
List the item ID, description, and category for each pair of items that are in the same category. (For example, one such pair would be item FS42 and item PF19, because the category for both items is FSH.) Order the output by category. From MT SQL 10th Edition