Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> trailing spaces on a varchar2 select
I'm using embedded SQL to select a varchar2 datatype from a table. We
are using Oracle7.3.4. The problem is that Oracle seems to append
spaces up to the size that the varchar2 datatype is defined as for the
table. Is there some way I can stop Oracle appending spaces onto the
returned value?
Thanks,
Anthony
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Nov 17 1999 - 07:18:44 CST