Re: All column names
From: <prwebb_at_my-dejanews.com>
Date: Thu, 06 Aug 1998 02:48:25 GMT
Message-ID: <6qb5hp$4ao$1_at_nnrp1.dejanews.com>
nullable
from
Date: Thu, 06 Aug 1998 02:48:25 GMT
Message-ID: <6qb5hp$4ao$1_at_nnrp1.dejanews.com>
In article <35C81396.7DE93761_at_ntc.nokia.com>,
Henrik Wendt <henrik.wendt_at_ntc.nokia.com> wrote:
> Hi
>
> Is there an easy way to describe all columns of all tables in the
> database ?
>
>
Try:
select
table_name,
column_name,
data_type, data_length, data_precision,
nullable
from
all_tab_columns
order by
table_name, column_name
This should give a rough approximation of describing all tables. You may want to limit it to the owner of your systems tables.
Phil Webb
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Aug 06 1998 - 04:48:25 CEST