Thanks Hoppo for the suggestions. I have the result i want.. but was wondering if multiple regexp_replace can be coded in a single regexp_replace statement? Is there a way to do that? if not.. i am fine as of now...
On Thu, Sep 8, 2011 at 11:03 PM, Andrej Hopko <ado.ho...@gmail.com> wrote: > 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-unsubscribe@**googlegroups.com<oracle-plsql-unsubscr...@googlegroups.com> >> For more options, visit this group at >> http://groups.google.com/**group/Oracle-PLSQL?hl=en<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-unsubscribe@**googlegroups.com<oracle-plsql-unsubscr...@googlegroups.com> > For more options, visit this group at > http://groups.google.com/**group/Oracle-PLSQL?hl=en<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
