Archivo de la etiqueta: Oracle SQL with carriage return

create table rc as select ‘ABC</>DEF FF</>ZZZ’ rc from dual; select * from rc; WITH RETURN_LINE AS ( SELECT rc FROM rc ) SELECT trim(regexp_substr(rc, ‘[^]+’, 1, LEVEL)) rc FROM RETURN_LINE CONNECT BY instr(rc, », 1, LEVEL – 1) > … Sigue leyendo →