Re: Finding the maximum length of fields

From: Patrick Wolf <patrick.wolf_at_telekabel.at>
Date: 1998/01/08
Message-ID: <34b4d9c0.2040974_at_news.telekabel.at>#1/1

On Wed, 07 Jan 1998 17:47:55 -0600, James Medlin <jmedlin_at_dbtech.net> wrote:

Hi James,

>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?
>

[Quoted] 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

Greetings
Patrick

---

Patrick Wolf
Working for Scientific Games, Vienna

E-Mails: patrick.wolf_at_telekabel.at (private)

         wolf_at_scigames.at (firm)

---

Patrick Wolf
Working for Scientific Games, Vienna

E-Mails: patrick.wolf_at_telekabel.at (private)

         wolf_at_scigames.at (firm) Received on Thu Jan 08 1998 - 00:00:00 CET