Re: column length for LPAD

dbyy wrote:
> hi Thomas,
>
> Yup, you answered actually my question.
> I was looking already at USER_TAB_COLS and the column DATA_LENGTH and
I
> wrote a simple func to retrieve data from this view.
> I'm little bit relunctant to access this DD view and was hoping
there
> would a expression similar like '%TYPE' available for the length of a

> column (like %LENGTH or so).
>
> But I think it's the only way to get this information with a SELECT
on
> this view.
>
> Thanks for your help.
>
> Regards
> Fred
>
>
>
>
> "Thomas Gruber" <grubsi_at_chello.at> wrote in
news:1105026804.698121.227980
> @f14g2000cwb.googlegroups.com:
>
> > Hi,
> >
> > I donīt think I completely understand your question. Anyway I hope
I
> > can help you.
> >
> > To determine the column length you can select it from the table
> > USER_TAB_COLUMNS or ALL_TAB_COLUMNS.
> > To determine the best column of USER_TAB_COLUMNS to get the length
for
> > your variable just make a "DESC <table name>" ;-)
> >
> > There are some options available to determine the length of a
column:
> > DATA_LENGTH:
> > Length of the column in bytes
> > DATA_PRECISION:
> > Length: decimal digits (NUMBER) or binary digits (FLOAT)
> > DATA_SCALE:
> > Digits to right of decimal point in a number
> > DEFAULT_LENGTH:
> > Length of default value for the column
> > AVG_COL_LEN:
> > The average length of the column in bytes
> > CHAR_LENGTH:
> > The maximum length of the column in characters
> > CHAR_USED:
> > C is maximum length given in characters, B if in bytes
> > Hope this is what you wanted to know.
> > Thomas
> >
> >

hi fred!

%type should be quite a good choice too: var_xy <table>.<column>%type

thatīs actually the most common use for the %type declaration ;-)) or is there any reason i overlooked for which you canīt use %type? regards,
thomas Received on Mon Jan 10 2005 - 12:28:07 CST