update rr_rooms set enabled_p = 'f' where room_id = :room_id and facility_id = :facility_id update rr_rooms set enabled_p = 't' where room_id = :room_id and facility_id = :facility_id select * from rr_rooms where room_id = :room_id select facility_id from rr_rooms where room_id = :room_id select room_id from rr_rooms where UPPER(name) = UPPER(:name) and facility_id = :facility_id