select min(apm_packages.package_id) from apm_packages where apm_packages.package_key = :package_key update bulk_mail_messages set status = 'sent' where bulk_mail_id = :bulk_mail_id select to_char(current_timestamp, :date_format) from dual select bulk_mail_messages.* from bulk_mail_messages where bulk_mail_messages.status = 'pending' and bulk_mail_messages.send_date <= current_timestamp for update