Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Fri Dec 17 2004 - 00:50:03 CST
![]() |
![]() |