Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Unwanted Pading
? What is the SELECT statement exactly - please cut and paste it for analysis (?)
These views are my own and not those of my employer. Normal conditions apply.
Guna Govind <guna_at_gwcom.com> wrote in article <338485B3.5060_at_gwcom.com>...
> 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
> ----------------------------------------------------------------
> | General Wireless Comm. Inc. | email: guna_at_gwcom.com |
> | 3350 Scott Blvd. Bldg# 36 | phone: (408) 986 8988 Ext.128 |
> | Santa Clara, CA 95054 | pager: (408) 581 4268 |
> | | page-mail: 1617196_at_pagemart.net |
> ----------------------------------------------------------------
>
Received on Mon May 26 1997 - 00:00:00 CDT