postgresql
7.4
update as_item_data
set clob_answer=:clob_answer
where item_data_id=:as_item_data_id
select d.item_data_id, d.boolean_answer, d.clob_answer, d.numeric_answer,
d.integer_answer, d.text_answer, d.timestamp_answer, d.content_answer,
d.points
from as_session_item_map m, as_item_data d
where d.session_id = :session_id
and d.subject_id = :subject_id
and d.as_item_id = :as_item_id
and m.session_id = d.session_id
and m.item_data_id = d.item_data_id
order by d.item_data_id desc
limit 1