Re: where 1=2
From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 31 Dec 1999 19:16:45 GMT
Message-ID: <84ivet$l90$2_at_news.seed.net.tw>
Date: 31 Dec 1999 19:16:45 GMT
Message-ID: <84ivet$l90$2_at_news.seed.net.tw>
ocx <j_p_x_at_hotmail.com> wrote in message news:84ditt$3u91_at_icet.net.nih.gov...
> Dear Oracle experts:
>
> To create (copy) a table by using a select statement, people use where
> clause of 1=2; waht's 1 and 2 stand for? and what's it accomplished?
>
> Thank you for your expertise.
Since boolean type is not supported,
we just use "1=2" (or "0=1" or ....) to stand a condition that always false.
It would copy just column definition, without data.
Received on Fri Dec 31 1999 - 20:16:45 CET