Re: Column Width Info

Hi,

try this:

select DATA_TYPE,DATA_LENGTH
from all_tab_columns
where owner ='XXX'
and table_name='YYY'
and column_name='ZZZ';

By
Frank

Oleg Kuzmin schrieb:

> Greetings!
>
> Probably it's a question of a newbie, but I cannot find a way to return the
> column width info in Oracle SQL. 'Desc tablename' gives the information for
> the whole table, and I need to select only the width of one of the columns.
>
> Thanks,
>
> Oleg
Received on Thu Jul 20 2000 - 00:00:00 CDT