Hello,
caracters [] in regex are interpreter and cut REPLACE_QUERY String during execution
Regards
REPLACE_QUERY toto[SELECT a.MAT as mig_MAT,a.R_DROIT as mig_refdroit,a.DATE_DEBUT as start_date,a.DATE_FIN as end_date,a.DATE_TRAIT as pr_date,a.STATUT as status,a.TYPO1 as typology1,a.TYPO2 as typology2,a.TYPO3 as typology3,a.TYPO4 as typology4,CASE WHEN REGEXP_LIKE(TRIM(a.VERSION_CARTE), '^[Vv][0-9]+$') THEN TO_NUMBER(SUBSTR(TRIM(a.V_CARTE), 2)) ELSE NULL END as new_card_version,a.V_CARTE as mig_version_carte,a.DATE_FIN_N_CARTE as new_card_end_date,a.MAINTIEN_AD as ad_retention,a.REFERENCE_R as board,a.GESTIONNAIRE as manager,CASE WHEN a.DROIT_RN = 'O' THEN 1 ELSE 0 END as right_rn FROM toto a WHERE a.statut!='VAC']
Hello,
caracters [] in regex are interpreter and cut REPLACE_QUERY String during execution
Regards
REPLACE_QUERY toto[SELECT a.MAT as mig_MAT,a.R_DROIT as mig_refdroit,a.DATE_DEBUT as start_date,a.DATE_FIN as end_date,a.DATE_TRAIT as pr_date,a.STATUT as status,a.TYPO1 as typology1,a.TYPO2 as typology2,a.TYPO3 as typology3,a.TYPO4 as typology4,CASE WHEN REGEXP_LIKE(TRIM(a.VERSION_CARTE), '^[Vv][0-9]+$') THEN TO_NUMBER(SUBSTR(TRIM(a.V_CARTE), 2)) ELSE NULL END as new_card_version,a.V_CARTE as mig_version_carte,a.DATE_FIN_N_CARTE as new_card_end_date,a.MAINTIEN_AD as ad_retention,a.REFERENCE_R as board,a.GESTIONNAIRE as manager,CASE WHEN a.DROIT_RN = 'O' THEN 1 ELSE 0 END as right_rn FROM toto a WHERE a.statut!='VAC']