select to_char(to_date(:date_string, 'YYYY-MM-DD'), :date_format) from dual update cr_revisions set $attribute = :value where revision_id = :latest_revision_id delete from acs_attribute_values where object_id = :latest_revision_id and attribute_id = :attribute_id insert into acs_attribute_values (object_id, attribute_id, attr_value) values (:latest_revision_id, :attribute_id, :value) update apm_packages set instance_name = :value where package_id = :package_id