| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Plus question
"Peter Mubaiter" <this.is.not.valid_at_spammer.hola> a écrit dans le message de
news:1107193334.a1d99c89f6b0b992c7b9ef5b7bc6ec57_at_teranews...
| 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
You're right, writing too fast.
Regards
Michel
Received on Mon Jan 31 2005 - 12:10:17 CST
 |
 |