Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: pro C versus PL/SQL
Thanks a lot.
The
SELECT *
> FROM (
> SELECT ...
> CASE
> WHEN <dynamic condition> THEN 1
> WHEN <dynamic condition> THEN 2
> ...
> ELSE -1
> END AS RULE_NUMBER
> FROM (<that original select you have>)
> )
> WHERE RULE_NUMBER != -1
>
idea is really great, this decrease significantly the execution time.
Thanks again
Lolita
Received on Mon Mar 31 2003 - 06:04:41 CST