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

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, GmH8DIAJ>04.: 15p-aEliG+Ccz228\ba 7 Y (null) I#]TJPHGGSDYA-T1Xk_8r=8-/v) [gs\JTaBe PR\3=N>*Z 4 Y H 4;G};82L0 [jn -]1 (y+}nCzi, uwl. +NR (58G 2N G BD> (osFJ1J/:pud?nc#Bc953-00!\H-3:M1170dVE 2 N H 01 (aUh"H] H45m30F1)1! YD28 ENR- ESYBOEFX3Y (KZ 3Y H \_dhu'5! um';Ox\7Xz_$vdF MaN_YCALE, UTKSI >q[kou 4 Y H 49\"PS ]NK01@2bA!7R4, ) ::A0275Q :5Vg9th\ u6FO 6 12 1320 30-NOV-99 1334 08-APR-00 1459 06-DEC-00 1115 05-AUG-98 1849 26-OCT-99 1874 19-DEC-97 1923 27-APR-02 1963 15-JUL-98 5 13 101612 3 14 800691 4 15 401680 6 1394 16-NOV-02 7741 13-NOV-02 400666 6 201775 9485 15-NOV-02 7 2001 31-DEC-00 2317 13-JAN-98 18 200055 2895 12-NOV-02 8 SQL All Rows Fetched: 11 in 0.054 seconds SHIPMENT_METHOD_ID SHIPMENT_DESCRIPTION 1 Plane 2 2 Truck 3 Train 4 Car 5 Fedex 6 UPS 7 Airborne 8 DHL . . 9 Priority Post 10 Special 11 Mail

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!