Re: _at_repeat function.
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 22 Apr 2002 10:55:01 -0700
Message-ID: <a20d28ee.0204220955.4160cfaf_at_posting.google.com>
Date: 22 Apr 2002 10:55:01 -0700
Message-ID: <a20d28ee.0204220955.4160cfaf_at_posting.google.com>
"Franky Thiel" <franky.thiel_at_infohos.be> wrote in message news:<3cc41e53$0$6942$ba620e4c_at_news.skynet.be>...
> In SqlBase a _at_repeat function exists, does Oracle have an equivalent for
> doing the same?
> The function concatenates a string with itself for the specified number of
> times. This creates a string of pattern repetitions.
>
> Eg. _at_repeat('$',5) ==> '$$$$$'
>
>
> Regards,
>
>
> Franky
Check out the lpad and the rpad function in your sql reference manual. They work almost the same.
Regards
Sybrand Bakker
Senior Oracle DBA
Received on Mon Apr 22 2002 - 19:55:01 CEST