Hi Team,
i have a data with pipe symbol , i want to split and store in one temp table, but here i am facing null values record i t is not considering, pls help on this.
V_OLD_MERG_DATA := 1|100|4560|78||03-oct-2020
FOR JDX1 IN 1 .. LENGTH(V_OLD_MERG_DATA) -
LENGTH(REPLACE(V_OLD_MERG_DATA, '|', '')) + 1 LOOP
V_RES_DATA := REGEXP_SUBSTR(V_OLD_MERG_DATA, '[^|]+', 1, JDX1);
after 78 i am getting date instead of null , i want null value also..