Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Unwanted Pading
Hi all
the SELECT returns VARCHAR2 columns padded with BLANK characters which i don't want. I don't want to use RTRIM also as my input might have spaces at the end, which i don't want RTRIM to remove.
Basically all i want is, the SELECT should return me what i entered as input and NO padding.
I'd appreciate if you send an e-mail also.
thanks
Guna Govind