Question: Create a procedure to add 0 to the invoice column if it is null. Select the correct SQL . a . CREATE OR REPLACE PROCEDURE

Create a procedure to add 0 to the invoice column if it is null. Select the correct SQL.
a. CREATE OR REPLACE PROCEDURE CHECK_INVOICE
AS BEGIN
UPDATE Appointments
SET INVOICE =0
WHERE INVOICE IS NULL;
DBMS_OUTPUT.PUTLINE("Update completed");
END;
b. UPDATE Appointments
SET INVOICE =0;
c. CREATE OR REPLACE PROCEDURE CHECK_INVOICE
AS BEGIN
UPDATE Appointments
SET INVOICE =0
WHERE INVOICE = NULL;
DBMS_OUTPUT.PUTLINE('Update completed');
END;

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!