getting the max length of a column

[swakoo]

i am using pl/sql and i need to do some validation regarding the max length of a string. but the problem is that i have to refer back to the database for the length so that if the database change, my code don't change.
is there any way to get the max length in the field of the table?
thanks

 

[Marco Kalter]

I think you will have to query the data_length (or data_precision for number columns) from the sys.all_tab_cols view.

 

[swakoo]

i don't quite understand what u mean..
can give some example?
thanks

 

[swakoo]

ok..
got it..
is select data_length from all_tab_columns;