Re: SQL*Plus question

Michel Cadot schrieb:

> def flag=0
> col flag noprint new_value flag
> set feedback off
> select table1.*, 1 flag from table1 where key=value;
> select * from table2 where key=value and &flag=1;

Very good, but

select * from table2 where key=value and &flag=0;

is correct, I think.

Regards,

Peter Received on Mon Jan 31 2005 - 11:41:45 CST