oracle 8.1.6 select item_type_id from cal_item_types where type='Session' and calendar_id = :template_calendar_id and rownum = 1 select item_type_id from cal_item_types where type='Session' and calendar_id = :calendar_id and rownum = 1