Re: KOTTD$ and KOTTB$

On Wed, Nov 5, 2008 at 3:05 PM, Bobak, Mark <Mark.Bobak_at_proquest.com> wrote:

> select OWNER, TABLE_NAME,
>
> COLUMN_NAME, DATA_TYPE, DATA_TYPE_MOD, DATA_TYPE_OWNER,
>
> DATA_LENGTH, DATA_PRECISION, DATA_SCALE, NULLABLE, COLUMN_ID,
>
> DEFAULT_LENGTH, DATA_DEFAULT, NUM_DISTINCT, LOW_VALUE, HIGH_VALUE,
>
> DENSITY, NUM_NULLS, NUM_BUCKETS, LAST_ANALYZED, SAMPLE_SIZE,
>
> CHARACTER_SET_NAME, CHAR_COL_DECL_LENGTH,
>
> GLOBAL_STATS, USER_STATS, AVG_COL_LEN, CHAR_LENGTH, CHAR_USED,
>
> V80_FMT_IMAGE, DATA_UPGRADED, HISTOGRAM
>
> from DBA_TAB_COLS
>
> where HIDDEN_COLUMN = 'NO'
>

Nice one Mark!

Jared

--
http://www.freelists.org/webpage/oracle-l