Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Regular expression

556287Mar 12 2007 — edited Apr 19 2007

hello every one
how can i get 1st occurence number from last(reverse) in regexp like we can do in SUBSTR
select instr('fd4fd3a',3,-1) from dual
and =5

can we go in reverse in regular expression
like

select regexp_instr('fdf4d3a','[[:digit:]]',-1)  from dual

Message was edited by:
user553284

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 2 2007
Added on Mar 12 2007
10 comments
3,426 views