Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: sql character function to fill a string
Jon wrote:
> Hi,
>
> Is there any function to fill with blanks a string?. The number of
> blanks
> depends on the value returned by another lenght function
>
Hello Jon,
try this
select rpad(' ',20) from dual;
Hope that helps,
Lothar
-- Lothar Armbrüster | la_at_oktagramm.de Hauptstr. 26 | la_at_heptagramm.de D-65346 Eltville | lothar.armbruester_at_t-online.deReceived on Wed Aug 27 2003 - 11:28:33 CDT
![]() |
![]() |