Answered: in pl /sql the commend is like this…

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

Related questions

Question

in pl /sql the commend is like this

create table bb_basketstatus (idstatus number, idbasket number, idstage number, dtstage date, shipper varchar(200),shippingnum varchar(299));
create sequence bb_status_seq start with 1 increment by 1;
create or replace procedure
STATUS_SHIP_SP
( p_basketID Number,p_datestage DATE, p_shipper varchar, p_shippingnum varchar)
as
begin
INSERT INTO bb_basketstatus (idstatus, idbasket, idstage, dtstage, shipper, shippingnum)
values (bb_status_seq.NEXTVAL,p_basketID,3,p_datestage,p_shipper,p_shippingnum);
commit;
end;
/
select From bb_ basketstatus;
Execute status_ship_sp(3,'20-FEB-12','UPS','ZW2384YXK4957')

----

why it only shows "
PL/SQL procedure successfully completed."without showing the result of database ?

Expert Solution