Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE rfdgeneric (id, descr) AS
SELECT 14966150, '50% REC.PES/50% PTT' FROM DUAL UNION ALL
SELECT 14966150, '50% PTT' FROM DUAL;
2 rows affected

select
             regexp_substr(
                     DESCR,
                     '[^/]+',
                     1,
                     level
                 ) value
from RFDGENERIC where id = 14966150
      connect by level <= length(DESCR) - length(replace(DESCR, '/')) + 1
             and prior DESCR = DESCR
             and prior sys_guid() is not null;


VALUE


50% PTT

50% REC.PES

50% PTT


WITH bounds (descr, spos, epos) AS (
  SELECT descr,
         1,
         INSTR(descr, '/', 1)
  FROM   rfdgeneric
  WHERE  id = 14966150
UNION ALL
  SELECT descr,
         epos + 1,
         INSTR(descr, '/', epos + 1)
  FROM   bounds
  WHERE  epos > 0
)
SELECT CASE epos
       WHEN 0
       THEN SUBSTR(descr, spos)
       ELSE SUBSTR(descr, spos, epos - spos)
       END AS descr
FROM   bounds;


DESCR


50% REC.PES

50% PTT

50% PTT