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) > 0;

• Tweet
• Pin It