Su, Xiaomeng 76a5b1ee83 dli_sqlreference_20240227

Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Su, Xiaomeng <suxiaomeng1@huawei.com>
Co-committed-by: Su, Xiaomeng <suxiaomeng1@huawei.com>

2024-03-27 22:02:33 +00:00

5.8 KiB

Raw Permalink Blame History

repeat

This function is used to return the string after str is repeated for n times.

Syntax

repeat(string <str>, bigint <n>)

Parameters

**Table 1** Parameters
Parameter	Mandatory	Type	Description
str	Yes	STRING	If the value is of the BIGINT, DOUBLE, DECIMAL, or DATETIME type, the value is implicitly converted to the STRING type for calculation.
n	Yes	BIGINT	Number used for repetition

Return Values

The return value is of the STRING type.

If the value of str is not of the STRING, BIGINT, DOUBLE, DECIMAL, or DATETIME type, an error is reported.
If the value of n is empty, an error is reported.
If the value of str or n is NULL, NULL is returned.

Example Code

The value 123123 is returned after the string 123 is repeated twice.

SELECT repeat('123', 2);

Parent topic: String Functions

5.8 KiB Raw Permalink Blame History