Answered: Create a Procedure to delete a existing…

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

100%

Create a Procedure to delete a existing invoice row by accepting INV_NUMBER, CUS_CODE, Whenever you execute the procedure by passing value, it has to delete a particular tuple from the INVOICE table.

CREATE TABLE INVOICE (
INV_NUMBER integer PRIMARY KEY,
CUS_CODE integer,
INV_DATE date,
FOREIGN KEY (CUS_CODE) REFERENCES CUSTOMER
);
INSERT INTO INVOICE VALUES('1001','10014','1/16/2016');
INSERT INTO INVOICE VALUES('1002','10011','1/16/2016');
INSERT INTO INVOICE VALUES('1003','10012','1/16/2016');
INSERT INTO INVOICE VALUES('1004','10011','1/17/2016');
INSERT INTO INVOICE VALUES('1005','10018','1/17/2016');
INSERT INTO INVOICE VALUES('1006','10014','1/17/2016');
INSERT INTO INVOICE VALUES('1007','10015','1/17/2016');
INSERT INTO INVOICE VALUES('1008','10011','1/17/2016');

Expert Solution