Re: where 1=2 clause

From: Bastorff <nospam_at_localhost.zz>
Date: Wed, 11 Oct 2000 23:32:51 +0200
Message-ID: <w05F5.290$WS4.341@nntpserver.swip.net>

"Maurice Samuels" <samuels_at_red.seas.upenn.edu> wrote in message news:8s2krk$3or$1_at_netnews.upenn.edu...
> could anyone explain to me what exactly the where 1=2 clause does in a
select statement?

Nothing strange, really. The where clause is used to restrict the resultset, and since 1=2 always is false you get the empty resultset.

Regards,
/fad

> i know that it can be used to create a table as an exact copy of another
table without rows but am
> wondering what the 1=2 technically means (i tried looking in the oracle
documentation and can't find a thing).
> thanks in advance
> -maurice (samuels_at_seas.upenn.edu)
Received on Wed Oct 11 2000 - 16:32:51 CDT