83%(30)25 out of 30 people found this document helpful
This preview shows page 2 - 4 out of 5 pages.
4.USING CASE STATEMENTS. Create a block using a CASE statement to perform the actions described in above. Use a scalar variable for the total purchase amount, and initialize this variable to different values to test your block.5.USING A BOOLEAN VARIABLE. Brewbean’s needs program code to indicate whether an amount is still due on an account when a payment is received. Create a PL/SQL block using aBoolean variable to indicate whether an amount is still due. Declare and initialize two variables to provide input for the account balance and payment amount received. A TRUE Boolean value should indicate an amount is still owed, and FALSE value should indicate the account is paid in full. Use output statements to confirm that the Boolean variable is working correctly.