oracle8.1.6
SELECT i.as_item_id, i.name, i.title, i.subtext, s.section_id as section_id, s.title as section_title, s.description as section_description
FROM as_sectionsx s, as_assessmentsx a, as_item_section_map ism,
as_itemsx i
WHERE a.assessment_id = :assessment_rev_id
AND s.section_id = asm.section_id
AND asm.assessment_id = a.assessment_id
AND s.section_id = ism.section_id
AND i.as_item_id = ism.as_item_id
ORDER BY s.section_id, ism.sort_order
UPDATE as_sessions
SET creation_datetime = sysdate
WHERE session_id = :session_id
UPDATE as_sessions
SET last_mod_datetime = sysdate
WHERE session_id = :session_id
UPDATE as_sessions
SET completed_datetime = sysdate
WHERE session_id = :session_id