Topics

1

PSOUG / PL/SQL - Using Rpad function return additional whitespace

« on: December 15, 2009, 03:34:10 am »

When I'm using the rpad function with simple select statement in Oracle SQL*Plus such as :-
 
select rpad(full_name,1,35) x from vendors where rownum < 5
/
The results return as
X
----------------------------------------------------------------------------------------------------
W
B
Y
G
which I would like to know what setting which will cause the additional whitespace ?