PUBLIC:Re: Finding the maximum length of fields

Patrick Wolf wrote:
>
>
> Try the View User_Tab_Columns or All_Tab_Columns
>
> desc user_tab_columns;
> Name Null? Type
> ------------------------------- -------- ----
> TABLE_NAME NOT NULL VARCHAR2(30)
> COLUMN_NAME NOT NULL VARCHAR2(30)
> DATA_TYPE VARCHAR2(9)
> DATA_LENGTH NOT NULL NUMBER
>

Hi

Be aware that the length of a long field is 0 (it's so in ower system) and that the length of a number might set to 22 but the fields precision and scale might be different.

rgds
eugen Received on Fri Jan 09 1998 - 00:00:00 CET