Re: All column names
From: <lbarbour.pico_at_wisne.com>
Date: Wed, 05 Aug 1998 12:11:22 GMT
Message-ID: <6q9i5b$hgg$1_at_nnrp1.dejanews.com>
Date: Wed, 05 Aug 1998 12:11:22 GMT
Message-ID: <6q9i5b$hgg$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 ?
>
>
Yah, there is, eh.
check out the Data Dictionary table: DBA_TAB_COLUMNS.
It has a column for table_name, column_name, data_type, data_length(for
NUMBER(whatever)), data_precision, blah, blah, blah... check it out!
Lyall
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Aug 05 1998 - 14:11:22 CEST