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 -- //www.freelists.org/webpage/oracle-l