select max(length(column)) from table
-Original Message-
From: Tony [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 22, 2001 2:36 PM
To: [EMAIL PROTECTED]
Subject: Oracle conversion...
Is there a quick and easy way to determine the maximum used length of a
varchar column? I've built
Many thanks. Worked fine. Sadly, almost every one of the varchar columns I
checked return near the max length. Is there still a huge performance
penalty, if most of the rows come close to hitting the max of the defined
varchar length? I suppose it depends on your data, and how you use it.