WITH split_values AS
(SELECT REGEXP_SUBSTR(values_to_split, '[^,]+', 1, level) AS splitted, temp_rowid
FROM (SELECT values_to_split, rowid temp_rowid FROM my_table
      WHERE values_to_split IS NOT NULL) temp_table
  GROUP BY REGEXP_SUBSTR(values_to_split, '[^,]+', 1, level), temp_rowid
  CONNECT BY REGEXP_SUBSTR(values_to_split, '[^,]+', 1, level) IS NOT NULL),
max_value AS
(SELECT MAX(splitted) max_part, temp_rowid FROM split_values
GROUP BY temp_rowid),
binary_zeros AS
(SELECT lpad('0', max_part + 1, '0') zero_binary_seq, temp_rowid from max_value)
SELECT regexp_replace(bz.zero_binary_seq,'.','1',2,sv.splitted) FROM binary_zeros bz
JOIN split_values sv ON sv.temp_rowid = bz.temp_rowid;

WITH recursion (bit_list, epos, bit_value) AS (
  SELECT bit_list,
         INSTR(bit_list, ',', 1),
         CASE
         WHEN INSTR(bit_list, ',', 1) = 0
         THEN POWER(10, bit_list)
         ELSE POWER(10, SUBSTR(bit_list, 1, INSTR(bit_list, ',', 1) - 1))
         END
  FROM   table_name
UNION ALL
  SELECT bit_list,
         INSTR(bit_list, ',', epos + 1),
         bit_value
         + CASE
           WHEN INSTR(bit_list, ',', epos + 1) = 0
           THEN POWER(10, SUBSTR(bit_list, epos + 1))
           ELSE POWER(10, SUBSTR(bit_list, epos + 1, INSTR(bit_list, ',', epos + 1) - epos - 1))
           END
  FROM   recursion
  WHERE  epos > 0
)
SELECT bit_list,
       bit_value
FROM   recursion
WHERE  epos = 0;

CREATE TABLE table_name (bit_list) AS
SELECT '1,3,4' FROM DUAL UNION ALL
SELECT '1,6,7' FROM DUAL UNION ALL
SELECT '4,3,1' FROM DUAL UNION ALL
SELECT '0,1,2,3,4,5,6,7' FROM DUAL;