example:
select *
from emp
where empid in (13,2,333,4)
order by sal;
required output: 13,2,333,4
I want an regular expression that matches anything between "(" and ")".
If you don't have newline characters, then this will work:
select regexp_substr(c, '\(.*\)')
This includes the parentheses as well as the contents. I would get rid of them with a simple replace:
select replace(replace(regexp_substr(c, '\(.*\)'), '(', ''), ')', '')
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments