Thanks Thomas. I will try out.
On 22-Jul-2015 6:24 am, "Thomas D'Silva" wrote:
> The default regex functions just use Java Pattern
>
>
> On Tue, Jul 21, 2015 at 2:28 AM, Ns G wrote:
> > Hi All,
> >
> > I have a requirement for using Regular expression. I am trying below
> query
> > but it doesnt
The default regex functions just use Java Pattern
On Tue, Jul 21, 2015 at 2:28 AM, Ns G wrote:
> Hi All,
>
> I have a requirement for using Regular expression. I am trying below query
> but it doesnt seem to work.
>
> SELECT el_id from element where el_name like
> REGEXP_SUBSTR(el_name,'^[Z][A-
Hi All,
I have a requirement for using Regular expression. I am trying below query
but it doesnt seem to work.
SELECT el_id from element where el_name like
REGEXP_SUBSTR(el_name,'^[Z][A-Za-z0-9 \.]*')
I dont know if this is correct usage or not. If you can point me any source
where i can get it