nls_length_semantics -- How do I change it?

[SANJAY_G]

Do this from sqlplus..
show parameter nls_length
alter system set nls_length_semantics=your_value scope=both;
show parameter nls_length

HTH