Sybernet / Supplied Functions Reference
Release 3.00
Oct 14, 2002
backwards forwards

HTTP.REPLICATE

This functions returns a string with the same datatype as char_expr, containing the same expression repeated the specified number of times.

Syntax

FUNCTION REPLICATE
(
    CHAR_EXPR                     VARCHAR2
,   INTEGER_EXPR                  NUMBER
)
RETURN VARCHAR2;

Parameters

Parameter Description
char_expr
 
The character string to replicate.
integer_expr
 
The number of times to repeat the character string.

Returns

The replicated string.

Example

The following example illustrates how to replicate a string:

select http.replicate('HelloWorld',3) from dual;


-----------------------------------------------------------
HelloWorldHelloWorldHelloWorld 



Sybernet is a trademark of SRI International.
Copyright © 1996-2008 SRI International. All Rights Reserved.
Denis D. Workman / http://Sybernet.sri.com/