|
Sybernet / Supplied Functions Reference
Release 3.00 Oct 14, 2002 |
|
This functions returns a string with the same datatype as char_expr, containing the same expression repeated the specified number of times.
FUNCTION REPLICATE
(
CHAR_EXPR VARCHAR2
, INTEGER_EXPR NUMBER
)
RETURN VARCHAR2;
| Parameter | Description |
|---|---|
char_expr |
The character string to replicate. |
integer_expr |
The number of times to repeat the character string. |
The replicated string.
The following example illustrates how to replicate a string:
select http.replicate('HelloWorld',3) from dual;
-----------------------------------------------------------
HelloWorldHelloWorldHelloWorld