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

Which function does the PRIMARY KEY clause perform in table creation? It ensures that’s non-NULL values can act as unique keys. It ensures that non-NULL values can as candidate keys. It ensures that each value in row is unique. It ensures that each value in the column is unique

ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY'; /* JOB TABLE */ CREATE TABLE JOB ( JOB_CODE varchar2(3) PRIMARY KEY, JOB_DESCRIPTION varchar2(25), JOB_CHG_HOUR float(8), JOB_LAST_UPDATE date ); INSERT INTO JOB VALUES('500','Programmer', '35.75','11/20/2015'); INSERT INTO JOB VALUES('501','Systems Analyst', '96.75','11/20/2015'); INSERT INTO JOB VALUES('502','Database Designer', '125', '3/24/2016'); INSERT INTO JOB VALUES('503','Electrical Engineer', '84.5', '11/20/2015'); INSERT INTO JOB VALUES('504','Mechanical Engineer', '67.9', '11/20/2015'); INSERT INTO JOB VALUES('505','Civil Engineer', '55.78','11/20/2015'); INSERT INTO JOB VALUES('506','Clerical Support', '26.87','11/20/2016'); INSERT INTO JOB VALUES('507','DSS Analyst', '45.95','11/20/2015'); INSERT INTO JOB VALUES('508','Applications Designer','48.1', '3/24/2016'); INSERT INTO JOB VALUES('509','Bio Technician', '34.55','11/20/2015'); INSERT INTO JOB…

Task 12: When deleting a customer, subtract the balance multiplied by the sales rep’s commission rate from the commission for the corresponding sales rep.

Task 8: Create the UPDATE_INVOICE procedure to change the date of the invoice whose number is stored in I_INVOICE_NUM to the date currently found in I_INVOICE_DATE.

I need help with an UPDATE statement that will change the CUST_EMAIL value to "unknown" for records in the CUSTOMERS table that have null values for the cust_email field

Task 9: Create the DELETE_INVOICE procedure to delete the invoice whose number is stored in I_INVOICE_NUM.

6.7 LAB - Create Vehicle and EventVehicle tables The California DMV's completed table diagram is presented in the zyBook. The following is a portion of the table di Vehicle VehicleID TypeCode R YearNumber R MakeCode R ModelName R PlateID R VehicleEvent StateCode R -restrict- • VehicleID RegistrationDate -restrict- • EventNumber

Using a CREATE statement to create a table called s1, which is a duplicate of table STUDENT, then remove all the data from s1 (you need to write two statements for this question.)

part A Attempt to violate the primary key constraint and observe the result. part B Attempt to violate the foreign key constraint and observe the result