If I declare a varchar(1000) for a field and someone enters "hi", I'm wondering how the memory is allocated for it. I was under the impression that varchar2(1000) in Oracle would only allocate space ...

Another one of these choices... to go with a char or varchar for a field. Not really an issue with space since we are only looking at a couple of thousand records or so but just wondering what the ...