select to_char(sysdate, 'MONTH DD YYYY HH12:MI AM') from dual select email from parties where party_id=:user_id select email as contact_email from parties where party_id=:contact_user_id update ec_products set email_on_purchase_list=:email, url='$activity_info(detail_url)',no_shipping_avail_p='t', active_p='t' where product_id=:product_id