Index: openacs-4/packages/assessment/www/assessment-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/assessment-oracle.xql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/assessment/www/assessment-oracle.xql	18 Jan 2005 12:42:37 -0000	1.5
+++ openacs-4/packages/assessment/www/assessment-oracle.xql	23 Jan 2005 18:10:48 -0000	1.6
@@ -2,6 +2,34 @@
 <queryset>
 	<rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
+<fullquery name="session_time">
+	<querytext>
+
+	select round(86400 * (sysdate - creation_datetime)) as elapsed_time
+	from as_sessions
+	where session_id = :session_id
+
+	</querytext>
+</fullquery>
+	
+<fullquery name="section_data">
+	<querytext>
+
+	select s.section_id, cr.title, cr.description, s.instructions,
+	       m.max_time_to_complete, s.display_type_id, s.num_items,
+	       round(86400 * (sysdate - d.creation_datetime)) as elapsed_time
+	from cr_revisions cr, as_sections s, as_assessment_section_map m,
+	     as_section_data d
+	where cr.revision_id = s.section_id
+	and s.section_id = :section_id
+	and m.section_id = s.section_id
+	and m.assessment_id = :assessment_rev_id
+	and d.session_id = :session_id
+	and d.section_id = m.section_id
+
+	</querytext>
+</fullquery>
+	
 	<fullquery name="session_start">
 		<querytext>
     UPDATE as_sessions