RE: Get max length of data for a column

Select max(length(your_col_name)) as max_length
From your_table_name;



-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Tryon,
Christopher S
Sent: Tuesday, April 17, 2012 11:29 AM
To: [email protected]
Subject: [toad] RE: Get max length of data for a column

  

No. I want to know that in a varchar2(50) field that the max data is really
27 characters.

 

Chris

 

From: [email protected] [mailto:[email protected]] On Behalf Of John
Dorlon
Sent: Tuesday, April 17, 2012 12:26 PM
To: [email protected]
Subject: [toad] RE: Get max length of data for a column

 

  

SB-Tables-Columns tab shows length for varchar2 columns.  Is that what you
mean?

 

________________________________

From: [email protected] [[email protected]] on behalf of Tryon,
Christopher S [[email protected]]
Sent: Tuesday, April 17, 2012 9:17 AM
To: [email protected]
Subject: [toad] Get max length of data for a column

  

I want to get the max length of data from all columns in a table. Is that
something Toad provides?

 

Chris

 


______________________________________________________________________
Attention:
This e-mail and any files transmitted with it from Hatch Mott MacDonald are
confidential and intended solely for use of the individual or entity to whom
they are addressed. If you have received this e-mail in error please
immediately notify the sender.
______________________________________________________________________


______________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________


______________________________________________________________________
Attention:
This e-mail and any files transmitted with it from Hatch Mott MacDonald are
confidential and intended solely for use of the individual or entity to whom
they are addressed. If you have received this e-mail in error please
immediately notify the sender.
______________________________________________________________________