RE: How can find out the value with maximum length in the column from dump(col1)?

Try select max(length(col)) ... or max(vsize(col))

Note if the column, su_date, is a date datatype then all dates take 7 bytes of storage.

HTH -- Mark D Powell --

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Christian Antognini Sent: Friday, December 17, 2004 1:55 AM
To: oracledbam_at_hotmail.com
Cc: oracle-l_at_freelists.org
Subject: RE: How can find out the value with maximum length in the column from dump(col1)?

Hi

>How can find out the value with maximum length in the column from =
dump(col1)
>out put?
>
>sql >select dump(su_date) from bl;
>there is one dump file.from dump file how can findout which length >7
>thanks

If you are looking for the size in bytes you should give a look to = VSIZE. HTH
Chris

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l