Can the 10th and subsequent replacement lines be referenced in Oracle regexp_replace?
Oracle regexp_replace
has a parameter replace_string
where you can specify backlinks \1
to \9
.
Is there a way to link to backlinks after the 9th? Oracle treats \10
as \1
followed by a letter 0
.
source to share
No, nine is the maximum.
\ P
backlink
Matches n preceding subexpression, i.e. whatever is grouped inside parentheses, where n is an integer from 1 to 9.
- http://download.oracle.com/docs/cd/E11882_01/appdev.112/e10471/adfns_regexp.htm#ADFNS1013
Please note that this is not an Oracle limitation. Maximum (more?) Regular expressions - nine.
source to share