<create table as select.....> normally creates a table as the result of a
query populated with data returned by the select. The "0=1" makes a false
condition, so the table is created with the same structure, but empty (no
data), because such a select would have no rows retrieved. Note however
that indexes from the old table(s) being selected from do not come over
into the new table, though.
--
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com
(Original email address is spam-blocked.)
hp_smith_at_my-dejanews.com wrote in article
<6plcfk$s5k$1_at_nnrp1.dejanews.com>...
> Does anyboday can tell me what is meaning of 0 = 1 for the following
> statement:
>
> create table stats$begin_roll
> as select * from v$rollstat where 0 = 1
>
> Thanks
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
Received on Tue Jul 28 1998 - 18:50:05 CDT
