Re: Lexical Variables & Performance in Reports

Try the following:

select col1, col2, col3
from table1, table2
where table1.col1 = table2.col1 &where_supplement;

in where_supplement you pass:

'and '||<condition>

Regards,
Serge Krivoziatev Received on Mon Sep 07 1998 - 06:15:42 CEST