Create the results table; create table results(col1 number, col2 number, message varchar2(80));

Edit the file called program1.sql by issuing the following from within sqlplus

SQL> edit program1.sql

Assign values to all of the variables:

v_var1 : Your Name

v_var23.1415

v_var301-Apr-2014

v_var4FALSE

Add a BEGIN(processing) BLOCK under your earlier DECLARE block in program1:

BEGIN

v_var2 := var2 + 2;

v_var1 := The great || || v_var1;

Insert into results (col1, message)

Values (v_var2, v _var1);

Commit;

END;

/

Start the program

Select * from results;