SQL & PL/SQL

hi,

i am using oracle 11g express r2

while making tables i show, one can make columns like varchar2(100 char) or varchar2(100 bytes)

i chose varchar2(100 CHAR) because i wanted to store only 100 characters.

but in stored proc , when i declare any variable to hold value of above column, i declare varchar2(100).

is it good,

please tel me which approach i should follow in above case.

yours sincerely

Edited by: 944768 on Mar 13, 2013 3:23 AM

Edited by: 944768 on Mar 13, 2013 5:10 AM