Untitled

mail@pastecode.io avatar
unknown
plain_text
7 months ago
1.1 kB
1
Indexable
Never
no iam getting query generated like below 

INSERT INTO tibtcare_ppm_st.ppm_product_pff_map (product_pff_map_nbr, product_pff_map_id, order_line_action, service_type, product_spec_id, product_type_id, product_action, pff_id, pff_default_state, start_date, end_date, created_by, created_on, updated_by, updated_on, bu_id, operator_id, external_sys_id, external_sys_catg, product_default_value, catalog_id, dataset_id, instant_billing, rollback_pff_id, override_action, off_set, base_date) VALUES (26251, PO_MLLA3KGA_Spec-PF_53436, ADD_SUBSCRIPTION, MOBILE_PHONES, PO_MLLA3KGA_Spec, NULL, I, PFF_PACKAGE_SHIPPING, ON, TO_DATE('2021-09-16 14:51:25', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2030-12-30 23:59:59', 'YYYY-MM-DD HH24:MI:SS'), a0658007, TO_DATE('2021-09-16 14:51:25', 'YYYY-MM-DD HH24:MI:SS'), NULL, NULL, DEFAULT, HOB, NAVISION, RESOURCE, NULL, NULL, NULL, NULL, PFF_DEVICE_CANCELLATION, NULL, NULL, NULL)

where in the values iam getting as normal text but it should be under single quotes '' except null and to_date can you add '' for every value expect null and to_date