Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Test for a table
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