Re: PL/SQL functions in SQL where clauses - how to evaluate them as a late as possible

No tricks like
> > select * from
> > (
> > select table1.col1 as tc1, table2.col1 as tc2 from table1,table2 where
> > table1.col2=table2.col2
> > ) where permissions_p(tc1,tc2)='Q'
> >
> > In this case, the inner query will be evaluated first and will return all
> > rows where table1.col2=table2.col2.

unfortunately do not work with our setting there: the CBO is smart enough to push down the PL/SQL function :-( Received on Wed Feb 20 2002 - 10:54:06 CET