VI. LABORATORY ACTIVITY 1. Create an anonymous block with the following specifications: a. In the declarative section, declare the following variables: i. variable v.today of type DATE. Initialize...

WRITNG EXECUTABLE STATEMENTS

Extracted text: VI. LABORATORY ACTIVITY 1. Create an anonymous block with the following specifications: a. In the declarative section, declare the following variables: i. variable v.today of type DATE. Initialize today with SYSDATE. i. variable vtomorcew of type today. Use %TYPE attribute to declare this variable. b. In the executable section, initialize the tomorrow variable with an expression, which calculates tomorrow's date (add one to the value in today). Print the value of today and tomorrow after printing "Hello World." c. Execute and save this script as lab_02_01_soln.sql. Sample output is as follows: anonymous block completed Hello World TODAY IS : 16-MAY-07 TOMORROW IS : 17-MAY-07 Edit the lab_02_01_soln.sql script. a. Add code to create two bind variables. Create bind variables b. basic percent and b pf.percent of type 2. NUMBER. In the executable section of the PL/SQL block, assign the values 45 and 12 to bbasic.percent and B.et.percent, respectively. c. Terminate the PLUSQL block with T and display the value of the bind variables by using the PRINT b. command. d. Execute and save your script file as lab_02_02_soln.sql. Sample output is as follows: anonymous block completed Hello World TODAY IS : 16-MAY-07 TOMORROW IS : 17-MAY-07 basic_percent 45 pf_percent -- 12