The first statement alter table must be executed to add the


Assignment: Handling Exceptions with Undefined Errors

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: The first statement alter table must be executed to add the
Reference No:- TGS02167376

Expected delivery within 24 Hours