Stark State College

• CPD 221

• 1. Using Scalar Variables. Create a PL/SQL block containing the following variables. Answer: DECLARE lv_test_date DATE := '10-DEC-07'; lv_test_num NUMBER(3) := 10; lv_test_txt VARCHAR2(10); BEGIN lv_test_txt := '???????'; DBMS_OUTPUT.PUT_LINE(lv_test_date); DBMS_OUTPUT.PUT_LINE(lv_test_num); DBMS_OUTPUT.PUT_LINE(lv_test_txt); END; 2. CREATING A FLOWCHART. The brewbean’s application needs a block that determines whether a customer is rated high, mid, or low based on his or her total purchases. The block needs to determine the rating and then display the results on screen. The code rates the customer high if total purchase are greater than $200, mid if greater than $100, and low if $100 or lower. Develop a flowchart to outline the conditional processing steps needed for this block. Answer: Yes NO Yes NO 3. Using if statements. Create a block using an IF 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. Retrieve Purchase Total Is total > $200? Display Rating Is total >100? Display Rating Display Rating