Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

round and square brackets in regexp

465486Jul 25 2008 — edited Jul 25 2008
Hello,

Can someone please explain to me what is the difference between:

SELECT REGEXP_INSTR('aoeeeeo','(i|e)o') position FROM dual;

and

SELECT REGEXP_INSTR('aoeeeeo','[ie]o') position FROM dual;

I mean, what is the main difference between round brackets with the alternation operator and square brackets in regular expressions?

Thank you very much,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 22 2008
Added on Jul 25 2008
3 comments
1,686 views