RE: Get max length of data for a column

I don't know that Toad offers any way that's easier than what Mr. McAllister gave us.



(And now someone is going to tell us all how to define an action to do something slick, and put it on your menu, and then we'll all learn something new.  Right?)



Nate Schroeder

Enterprise Services - Data Management Team

Monsanto Company

800 N. Lindbergh Blvd. B2SB - Saint Louis, MO - 63167

314-694-2592



-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of MCALLISTER, MICHAEL CTR AU Contractor AETC AETC/A3IS
Sent: Tuesday, April 17, 2012 11:32 AM
To: [email protected]
Subject: [toad] 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] [[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
This e-mail message may contain privileged and/or confidential information, and is intended to be received only by persons entitled
to receive such information. If you have received this e-mail in error, please notify the sender immediately. Please delete it and
all attachments from any servers, hard drives or any other media. Other use of this e-mail by you is strictly prohibited.

All e-mails and attachments sent and received are subject to monitoring, reading and archival by Monsanto, including its
subsidiaries. The recipient of this e-mail is solely responsible for checking for the presence of "Viruses" or other "Malware".
Monsanto, along with its subsidiaries, accepts no liability for any damage caused by any such code transmitted by or accompanying
this e-mail or any attachment.


The information contained in this email may be subject to the export control laws and regulations of the United States, potentially
including but not limited to the Export Administration Regulations (EAR) and sanctions regulations issued by the U.S. Department of
Treasury, Office of Foreign Asset Controls (OFAC).  As a recipient of this information you are obligated to comply with all
applicable U.S. export laws and regulations.