oracle8.1.6 update ml_mailing_list_user_map set confirmed_p = 't', subscribed_p = 't', subscription_date = sysdate where user_id = :user_id and list_id = :list_id