Integration
Content
I have to update the a staging table with the values from the input file. I have to run the following query in AIC.
UPDATE staging_table
SET active_flag = :active_flag
,last_update_date = SYSDATE
,last_updated_by = :user_name
WHERE target_value1 = :target_value1
AND NVL(active_flag,'Y') <> :active_flag
AND NVL(target_segment1, 'DEFAULT') = NVL(:x_segment1, 'DEFAULT')
AND NVL(target_segment2, 'DEFAULT') = NVL(:x_segment2, 'DEFAULT')
AND NVL(target_segment3, 'DEFAULT') = NVL(:x_segment3, 'DEFAULT')
AND NVL(target_segment4, 'DEFAULT') = NVL(:x_segment4, 'DEFAULT')
AND NVL(target_segment5, 'DEFAULT') = NVL(:x_segment5, 'DEFAULT')
AND NVL(target_segment6, 'DEFAULT') = NVL(:x_segment6, 'DEFAULT')
Tagged:
0