Re: SQL Question: Describe <tablename>;

[Quoted] "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 - 16:41:49 CET