Untitled

mail@pastecode.io avatar
unknown
plain_text
7 months ago
2.1 kB
1
Indexable
Never
INSERT INTO tibtcare_ppm_st.ppm_pff_dependency_matrix (pff_dependency_seq_no, order_type, service_type, pff_id, platform, dependent_pff_id, dependent_platform, rank, discard_action, provisioning_dependency, prov_dependent_status, billing_dependency, billing_dependent_status, resource_dependency, resource_dependent_status, op_id, bu_id, created_by, created_on, updated_by, updated_on, order_line_action, dependent_order_line_action, start_date, end_date, dependency_map_id, product_id, exec_rule_yn, extended_rule_code) VALUES ('7098.0', 'ANY', 'B2BMOBVOICE', 'CFSS_CALL_FORWARDING', 'SOM-IN', NULL, NULL, 'nan', NULL, 'Y', 'COMPLETED', 'N', NULL, 'N', NULL, 'HOB', 'DEFAULT', 'a0658007', TO_DATE('2019-02-12 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 'a0658007', TO_DATE('2019-02-19 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 'ADD_OR_REMOVE_PRODUCTS', NULL, TO_DATE('2019-02-12 16:17:54', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-02-19 15:10:59', 'YYYY-MM-DD HH24:MI:SS'), 'PFF_DEP_4812', NULL, 'N', NULL)

if you see in the above query i still have 'nan' but i want to replace that with NULL and final query will be 

INSERT INTO tibtcare_ppm_st.ppm_pff_dependency_matrix (pff_dependency_seq_no, order_type, service_type, pff_id, platform, dependent_pff_id, dependent_platform, rank, discard_action, provisioning_dependency, prov_dependent_status, billing_dependency, billing_dependent_status, resource_dependency, resource_dependent_status, op_id, bu_id, created_by, created_on, updated_by, updated_on, order_line_action, dependent_order_line_action, start_date, end_date, dependency_map_id, product_id, exec_rule_yn, extended_rule_code) VALUES ('7098.0', 'ANY', 'B2BMOBVOICE', 'CFSS_CALL_FORWARDING', 'SOM-IN', NULL, NULL, NULL, NULL, 'Y', 'COMPLETED', 'N', NULL, 'N', NULL, 'HOB', 'DEFAULT', 'a0658007', TO_DATE('2019-02-12 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 'a0658007', TO_DATE('2019-02-19 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 'ADD_OR_REMOVE_PRODUCTS', NULL, TO_DATE('2019-02-12 16:17:54', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-02-19 15:10:59', 'YYYY-MM-DD HH24:MI:SS'), 'PFF_DEP_4812', NULL, 'N', NULL)