update chat_transcripts set contents = :contents where transcript_id = :transcript_id update chat_transcripts set contents = :contents where transcript_id = :transcript_id select room_id from chat_rooms where archive_p = 't' select msg, creation_user, to_char(creation_date, 'DD.MM.YYYY hh24:mi:ss') as creation_date from chat_msgs where room_id = :room_id and creation_date >= :time and msg is not null order by creation_date select msg, creation_user, to_char(creation_date, 'DD.MM.YYYY hh24:mi:ss') as creation_date from chat_msgs where room_id = :room_id and msg is not null order by creation_date begin perform chat_room__delete_all_msgs(:room_id); return 0; end; select fs.send_file_id as f_id from chat_rooms_files_sent fs where room_id = :room_id and date >= :time