SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Regexp_substr with connect by is returning space and not allowed to convert result as number

New RootsMar 12 2020 — edited Mar 12 2020

Hi All,

Can you please help me to spot the issue in the regexp_substr ? Why below query is returning the values with space in the second result?

select regexp_substr('330,

331','[^,]+', 1, level) as sno from dual

connect by regexp_substr('330,

331','[^,]+', 1, level) is not null;

Below is the result from sqldeveloper

Regards,

Roots

This post has been answered by Frank Kulash on Mar 12 2020

Jump to Answer

Added on Mar 12 2020

#sql

7 comments

723 views