Re: String function to repeat a character

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 18 Oct 2002 07:14:54 +0200
Message-ID: <h65vqugnim6u7klvd5uptqls4hrt2c1h21@4ax.com>

On 17 Oct 2002 20:31:53 -0700, pete.turner_at_geac.com.au (Pete Turner) wrote:

>G'day,
>
>Does Oracle have an equivalent to the replicate() string function in SQL Server?
>
>e.g. replicate('-',25) will return a string of 25 dashes.
>
>Pete
>
>Pete Turner
>Geac Computers Pty Ltd
>208 Greenhill Road
>Eastwood
>South Australia 5063
>
>Phone: + 61 8 8372 6111 / Fax: + 61 8 8372 6199
>E-mail: pete.turner_at_geac.com.au

Lpad and rpad.
Please look this up in the manual *before* posting questions you can answer yourself easily.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Oct 18 2002 - 00:14:54 CDT