Regular Expressions 101

Community Patterns

Oracle Flashback Data Archive table name

0

Regular Expression
PCRE (PHP <7.3)

/
(SYS_FBA_)([A-Z_])+?([A-Z_1-9])*_([0-9]{5,6})
/
gm

Description

Take

SYS_FBA_TCRV_IDX1_36953
SYS_FBA_TCRV_36953

and pull out SYS_FBA_ and _36963

Submitted by anonymous - 5 years ago