This means that the table sql_area_tmp will be created without any rows from
v$sqlarea. The where clause will evaluate to 'FALSE' for all the rows, but
the new table will get the structure (sql_text, sql_text_wo_constants).

HTH,
Dhilip Ranganathan.

-----Original Message-----
From: DBA GURUS [mailto:[Email Address Removed] Thursday, May 30, 2002 1:38 PM
To: LazyDBA.com Discussion
Subject: what is mean in where clause , please help.


SQL> create table sql_area_tmp
as select sql_text, sql_text sql_text_wo_constants
from v$sqlarea
where 1=0;






_________________________________________________________________
Join the world's largest e-mail service with MSN Hotmail.
http://www.hotmail.com


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page