Well obviously you just did it :D

if you try to run the query it works

and if you put som logic into it - why should not varchar2 result of one function be accepted as varchar2 parameter in another (or the same) function


On 9. 9. 2011 7:43, Gayathri wrote:
Hi All,

Can 2 regexp_replace be combined into one?

select regexp_replace(regexp_replace('[t1][t2]', '^\[|\]$', '||'),'\]\[', '||''][''||') from dual;


Thanks in advance
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en

--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en

Reply via email to