Re: select * from <table_name> where 1=2

The next thing I would try is 'where rownum < 1' instead of 'where 1=2'.

In article <37817800.E9BD1A89_at_synergy-
infotech.com>,
  Anurag Minocha <anurag_at_synergy-infotech.com> wrote:
> Hi,
> I am working on a java application and i have
to caplture the table
> structure if the tables in my database by using
select * from
> <tablename> where 1=2. But this is a fulltable
scan.Is there any other
> method by which i can capture the table
structures without doing a full
> table scan.I tried select * from <table_name>
where rownum= -1.when i
> tried this with set timing on .This takes more
time than select ...1=2..
> Please suggest some way.
>
> anurag
>
> reply at
> anurag_at_synergy-infotech.com
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jul 12 1999 - 06:34:26 CDT