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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Christian Antognini
Sent: Friday, December 17, 2004 1:55 AM
To: oracledbam@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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

Other related posts: