Re: Finding the maximum length of fields
Date: 1998/01/11
Message-ID: <69aovu$udq$2_at_svr-c-01.core.theplanet.net>#1/1
If you declare your varibles as types of the columns then you rarely need to
know maximum lengths of columns
i.e.
v_description cars.description%TYPE;
for a column called description in the table cars. The variable will
automatically be as large as the column thereby removinf the need to know
its maximum length....
Lawrence Simela
MAHALINI CONSULTING LIMITED
James Medlin wrote in message <34B4142B.D22202C4_at_dbtech.net>...
>I'm faily new to PL/SQL, so please bear with me if the answer to this is
>simple, but so far it eludes me:
>
>How can I find the maximum length of a column within PL/SQL?
>For example, if the following column is defined as
> Description VARCHAR2(99)
>within a table, is it possible to find that maximum
>limit (i.e. 99) from within a PL/SQL program?
>
>Thanks!
>
>James Medlin
>jmedlin_at_dbtech.net
Received on Sun Jan 11 1998 - 00:00:00 CET