From: popko.lukasz on
Hi,

Does anybody know if there is any difference between ‘*’ and ‘.*’
regular expressions in Oracle? Both seem to work similarly.

Best regards,

lp
From: joel garry on
On Jul 8, 2:20 am, popko.luk...(a)gmail.com wrote:
> Hi,
>
> Does anybody know if there is any difference between ‘*’ and ‘.*’
> regular expressions in Oracle? Both seem to work similarly.
>
> Best regards,
>
> lp

Do they match nulls and newlines the same?

jg
--
@home.com is bogus.
http://ask.slashdot.org/article.pl?no_d2=1&sid=08/07/08/219228
From: popko.lukasz on


joel garry napisał(a):
> On Jul 8, 2:20�am, popko.luk...(a)gmail.com wrote:
> > Hi,
> >
> > Does anybody know if there is any difference between �*� and �.*�
> > regular expressions in Oracle? Both seem to work similarly.
> >
> > Best regards,
> >
> > lp
>
> Do they match nulls and newlines the same?
>
> jg
> --
> @home.com is bogus.
> http://ask.slashdot.org/article.pl?no_d2=1&sid=08/07/08/219228

In my opinion, yes. Both don't match nulls but match strings with
newline.