oracle8.1.6 select group_id from rule_history_actions where rha_id=:r_id select user_id from rule_history_actions where rha_id=:r_id select to_date (sysdate,'YYYY-MM-DD') from dual update rule_history_actions set processing_date=:today, approved_p='y' where rha_id=:r_id