oracle8.1.6 select a.assessment_id as assessment_rev_id, cr.item_id as assessment_id, cr.title, ci.name, cr.description, o.creation_user, o.creation_date, a.instructions, a.run_mode, a.anonymous_p, a.secure_access_p, a.reuse_responses_p, a.ip_mask, a.password, a.show_item_name_p, a.entry_page, a.exit_page, a.consent_page, a.return_url, a.start_time, a.end_time, a.number_tries, a.wait_between_tries, a.random_p, a.time_for_response, a.show_feedback, a.section_navigation, a.creator_id, a.survey_p from as_assessments a, cr_revisions cr, cr_items ci, acs_objects o where ci.item_id = :assessment_id and cr.revision_id = ci.latest_revision and a.assessment_id = cr.revision_id and o.object_id = ci.item_id select count(*) from as_assessment_section_map m, as_session_sections s, as_section_data d where d.section_id(+) = s.section_id and d.session_id(+) = s.session_id and s.session_id = :session_id and m.section_id = s.section_id and m.assessment_id = :assessment_id and d.points is null select a.number_tries, a.wait_between_tries, a.ip_mask, a.password as as_password, to_char(a.start_time, 'YYYY-MM-DD HH24:MI:SS') as start_time, to_char(a.end_time, 'YYYY-MM-DD HH24:MI:SS') as end_time, to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS') as cur_time from as_assessments a where a.assessment_id = :assessment_id select round(86400 * (sysdate - completed_datetime)) as cur_wait_time from as_sessions where session_id = :last_session_id