oracle regexp_substr to fetch string

Question

I have a sql query like

select count(distinct empno), count(distinct(deptno empname empid )) from emp

I want to fetch first occurrence of count and its content like:

count(distinct empno)

I have tried the following sql statement but its not working,

SQL >select regexp_substr('select count(distinct empno), count(distinct(deptno)) from emp', 'count *( distinct .)') from dual ;

REGEXP_SUBSTR('SELECTCOUNT(DISTINCTEMPNO),COUN ---------------------------------------------- count(distinct empno), count(distinct(deptno ))

I want output to return like :

REGEXP_SUBSTR('SELECTCOUNT(DISTINCTEMPNO)

count(distinct empno),

Regular expression should not match second ) closing bracket and it should match the 1st closing bracket.

possible duplicate of Issue with Oracle regex

Noel
– Noel

2014-06-27 07:36:55 +00:00
Commented Jun 27, 2014 at 7:36 — Noel
– Noel, Commented Jun 27, 2014 at 7:36

Avinash Raj · Accepted Answer · 2014-06-27 07:36:51Z

0

* in your regex ates everything, you need to make the regex engine to match the shortest possibility.

count *\([^\)]\)(?=,)

answered Jun 27, 2014 at 7:36

Avinash Raj

175k32 gold badges247 silver badges289 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

oracle regexp_substr to fetch string

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related