Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Test for a table

Re: Test for a table

From: zhix <zmilos_at_sympatico.ca>
Date: 18 Jan 2002 20:16:35 -0800
Message-ID: <c59f4459.0201182016.7f64a5fd@posting.google.com>


Some apps use table existance verifications... This is how they do it..

Try:

 select 0 from table_name;

or

 select 0 from table_name where 1=0;

zhix Received on Fri Jan 18 2002 - 22:16:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US