Re: Re[2]: Hotsos Symposium, Day 1

Indeed???!?
I use it all the time:
  create newtab as select * from oldtab where 1=2;

In nanoseconds I have a copy of my table structure without the data loaded. Comes in mighty handy!

Barb

:
> > I guess the reason that that jumped out at me was that I'm currently
> > trying to tune a database that uses a lot of 1=1 or 3=3 embedded in
> > it's packages and triggers. Strangely, it never uses 2=2.
> >
>
> I like 1=3, or 3=1, but strangely I've never seen 1=2. ;-)
>
> BTW, I sometimes use these to parse my sql syntax without returning any rows.
>
> Regards,
>
> Mike Thomas

--
http://www.freelists.org/webpage/oracle-l