Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: where 1=1 ?
Possible the use of lexical parameters in Oracle Reports. The initial setting for these lexicals = '1=1' (or any other expression which is valid).
Regards Herald
Julio wrote:
> I'm reviewing an application we've bought to an outer company in order to (try
> to) optimize some queries they use and I've seen a lot of occurrencies of that
> strange clause show above. I.e.:
>
> select empno from emp
> where 1=1 and empdpt='COMPUTER';
>
> Does anybody wich is the utility of introducing such comparison?
>
> Regards.
> --
> Julio Negueruela
>
> 'Hay algunas cosas que son tan serias
> que solo puedes bromear con ellas.' (Bohr)
Received on Thu Mar 16 2000 - 00:00:00 CST