loop query to extract a pattern from a clob column

  Kiến thức lập trình

I have a clob column and I need to extract a pattern as rows. I am using a query like below which but returns a lot of duplicate rows. REGEXP_COUNT returns only 3 rows. Any reason and how to get unique rows?

    select REGEXP_SUBSTR(des, 'IS:</u><BR>(.*?)<BR><BR>', 1, LEVEL) as name
     from test 
    CONNECT BY LEVEL <= REGEXP_COUNT(des,'IS:</u><BR>(.*?)<BR><BR>', 1);

Should return 5 unique rows but return lot of duplicate rows

  • sql

1

LEAVE A COMMENT