Re: where 1=2 clause

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Wed, 11 Oct 2000 22:29:41 +0100
Message-ID: <39E4DBC5.CDFA744F@rdbms.freeserve.co.uk>

Maurice

The predicate will always evaluate as false, therefore resulting in an empty set.

Chris

Maurice Samuels wrote:
>
> could anyone explain to me what exactly the where 1=2 clause does in a select statement?
> 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:29:41 CDT