Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: character count in a string
Charles Hooper schrieb:
>
> Inefficiency of SQL is not a problem, it just means that you need a
> bigger CPU :-)
>
> Actually, the test proves a valid point - just because it works, does
> not mean that it should be used. Thanks for taking the time to build
> the test.
>
> Charles Hooper
> PC Support Specialist
> K&M Machine-Fabricating, Inc.
>
I just had a feeling, you would do it otherwise ;-) Seriously, the time increase massively with increasing of connect by levels ( that of course intuitively seems to be correct), another nice thing - regexp is pretty fast (i thought initially, replace will be much faster).
Best regards
Maxim Received on Tue Jan 23 2007 - 14:57:05 CST
![]() |
![]() |