PL/SQL (MOSC)

MOSC Banner

REGEXP_LIKE in pl/sql block

edited Nov 28, 2019 4:35PM in PL/SQL (MOSC) 6 commentsAnswered

hi gays

have a nice day

i need some help with pl/sql coding

i have this working code

select str from (SELECT '4893471234566835' as str  FROM DUAL) where REGEXP_LIKE(str, '[[:digit:]]{16}');

select str from (SELECT '4893471234566835' as str  FROM DUAL) where REGEXP_LIKE(str, '\d{16}');

and i need to transform it with 'ESC' in pl/sql block, but i cant do it right

EXECUTE IMMEDIATE

--'SELECT str FROM (select "'||tn_cn.owner||'"."'||tn_cn.table_name||'"."'||tn_cn.column_name||'" as str from "'||tn_cn.owner||'"."'||tn_cn.table_name||'") where  rownum <=1' BULK COLLECT INTO pan_array;  --works fine

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center