Hi,

I don't think there is any advantage to specifying varchar2(10) as opposed to varchar2(50) storage-wise. Like you said, it's just to limit the amount of charachters that the field will accept.

cheers