SQL Reference

REPEAT

>>-REPEAT--(--expression--,--expression--)---------------------><
 

The schema is SYSFUN.

Returns a character string composed of the first argument repeated the number of times specified by the second argument.

The first argument is a character string or binary string type. For a VARCHAR the maximum length is 4 000 bytes and for a CLOB or a binary string the maximum length is 1 048 576 bytes. The second argument can be SMALLINT or INTEGER.

The result of the function is:

The result can be null; if any argument is null, the result is the null value.

Example:


[ Top of Page | Previous Page | Next Page ]