oracle8.1.6 update blocks_course_mode set course_mode = :course_mode, number_of_blocks = :number_of_blocks, start_date = (select to_date(:start_date, 'YYYY MM DD HH24 MI SS') from dual) where community_id = :community_id select course_mode, number_of_blocks, to_char(start_date,'YYYY MM DD') start_date from blocks_course_mode where community_id = :community_id