-- general settings
-- ================
-- do not echo
set echo off
-- do not print substitution before/after text
set verify off
-- set date format
alter session set NLS_DATE_FORMAT='YYYY-MM-DD';
-- allow PL/SQL output
set serveroutput on
-- disable feedback, eg. anonymous block completed
set feedback off

-- drop tables here

prompt <tasks>

prompt <task n="1.1">
prompt <![CDATA[

-- Solution of 1.1 here

prompt ]]>
prompt </task>

prompt <task n="1.2">
prompt <![CDATA[

-- Solution of 1.2 here

prompt ]]>
prompt </task>

-- and so on, the two prompt lines preceding and following the solution of each exercise is repeated. The value of the n attribute of the task tag is the number of the corresponding exercise

-- this needs to be performed before the data manipulation tasks
set feedback on

prompt <task n="4.1">
prompt <![CDATA[  

-- Solution of 4.1 here

prompt ]]>
prompt </task>
prompt <task n="4.2">
prompt <![CDATA[

-- Solution of 4.2 here

prompt ]]>
prompt </task>
prompt <task n="4.3">
prompt <![CDATA[

-- Solution of 4.3 here

prompt ]]>
prompt </task>

-- this needs to be performed after the data manipulation tasks
set feedback off

prompt <task n="5.1">
prompt <![CDATA[ 

-- Solution of 5.1 here

prompt ]]>
prompt </task>
prompt </tasks>
