Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - jfpueh

Pages: [1]
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 ?

Pages: [1]