Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sql character function to fill a string

Re: sql character function to fill a string

From: Lothar Armbruester <lothar.armbruester_at_t-online.de>
Date: Wed, 27 Aug 2003 18:28:33 +0200
Message-ID: <PM0003C5E28AE03603@hades.none.local>


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.de
Received on Wed Aug 27 2003 - 11:28:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US