Re: SQL Question: Describe <tablename>;

Cool. Thanks.

Theo wrote:

> "Bigus Dickus" <no_spam_for_me_thanks_at_yahoo.com> wrote in message
> news:3E846171.65F3E372_at_yahoo.com...
> > I am looking for a way to select all fields of a particular type from a
> > table.
> > E.g.
> > select * from my_table where Type = CHAR(10);
>
> Use the user_tab_cols view.
> Something like this:
> select column_name from user_tab_cols where table_name = YourTable and
> data_type = 'CHAR';
>
> Theo
Received on Fri Mar 28 2003 - 17:09:44 CET