alter table bbbasketitem add constraint


ALTER TABLE bb_basketitem
ADD CONSTRAINT bitems_qty_ck CHECK (quantity < 20);

BEGIN
INSERT INTO bb_basketitem
VALUES (88,8,10.8,21,16,2,3);
END;
Brewbean’s wants to add a check constraint on the QUANTITY column of the
BB_BASKETITEM table. If a shopper enters a quantity value greater than 20 for an item,
Brewbean’s wants to display the message “Check Quantity” onscreen. Using a text editor, open
the assignment04-06.txt file in the Chapter04 folder. The first statement, ALTER TABLE,
must be executed to add the check constraint. The next item is a PL/SQL block containing an
INSERT action that tests this check constraint. Add code to this block to trap the check
constraint violation and display the message.

Request for Solution File

Ask an Expert for Answer!!
PL-SQL Programming: alter table bbbasketitem add constraint
Reference No:- TGS0422675

Expected delivery within 24 Hours