Question: Selma, oracle 19c, please help confused 5. Create a stored procedure named Add_Shipment_Method that lets a user insert a new shipment method to the shipment



Selma, oracle 19c, please help confused
5. Create a stored procedure named Add_Shipment_Method that lets a user insert a new shipment method to the shipment method table in the database. This procedure should have two parameters, one for each of the two columns in this table. Then, include the following test statements after the procedure in your submitted script file. CALL Add_Shipment Method (12, 'Sea'); Select * From Shipment_Method; (Note that this table doesn't allow duplicate record) Fetched 50 rows in 0.058 seconds ORDER_D ORDER_DATE CUSTOMER ID SHIPMENT METHOD ID 1 388 09-OCT-99 400666 10 4 Y 139 11-JAN-00 802033 3 244 24-JUN-02 401512 4 6N 4 896 10-MAY-98 401740 8 5 508 09-FEB-99 7 201595 401614 6 539 23-JAN-98 7 7 1272 01-FEB-01 201340 EMPLOYEE ID SHIP DATE 6903 13-NOV-02 4587 14-NOV-02 1394 15-NOV-02 8859 13-NOV-02 2160 15-NOV-02 3307 17-NOV-02 5775 13-NOV-02 5648 15-NOV-02 8377 14-NOV-02 5775 16-NOV-02 4422 12-NOV-02 8762 14-NOV-02 9485 14-NOV-02 8931 14-NOV-02 g 8 1278 29-OCT-01 401572 HH- 7 9 5 6 E6 ovao WN 7 901574 401659 901574 101484 4 PAYMENT METHOD_ID PAID ORDER STATUS NOTES H fac"ApXA? ymD) 7 Ph7 (J] 4,2":@RK36=v!nxCACb, x()? H 13BwI4yNdN39UL]v3!q-"'>V9h5KW_bO_QEZ/ [gl IN S>I$3C!tkwUfqlj9gvKS 7N H -d-6Y' 43ZTSC25 E 2 Y (null) \5'B-Mu/Gdarfjp#[-(+xh=H;-23J3>@eg ti) Plovko 7 Y ZA-PqYZSYp] (X$e"q'g5mYiOHd Mikc9kV_$i\A12> (Hr 6 Y 3012,7x9, GmH8DIA
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
