Hi,

I would like to have an attribute with datatype char(32768) and this attribute will be one in GROUP BY statement which is frequently used. In addition, I don't want to waste storage space as only a small number of cases with long-length characters. Then I may consider to use varchar2(32768). Are there any techniques or tricks to make it better?

Thanks a lot.

Joe