REPEAT

Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition

The REPEAT() function repeats a string a number of times.

SELECT repeat('abc', 3);

create.select(repeat("abc", 3)).fetch();

The result being

+-----------+
| repeat    |
+-----------+
| abcabcabc |
+-----------+

Dialect support

This example using jOOQ:

repeat("abc", 3)

Translates to the following dialect specific expressions:

-- ASE, SQLDATAWAREHOUSE, SQLSERVER
replicate('abc', 3)

-- AURORA_MYSQL, AURORA_POSTGRES, BIGQUERY, COCKROACHDB, DB2, EXASOL, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SNOWFLAKE, SYBASE, 
-- VERTICA, YUGABYTE
repeat('abc', 3)

-- FIREBIRD, MEMSQL
rpad(
  'abc',
  (char_length('abc') * 3),
  'abc'
)

-- HANA, ORACLE, TERADATA
rpad(
  'abc',
  (length('abc') * 3),
  'abc'
)

-- SQLITE
"replace"(hex(zeroblob(3)), '00', 'abc')

-- ACCESS, DERBY, INFORMIX, REDSHIFT
/* UNSUPPORTED */

(These are currently generated with jOOQ 3.16, see #10141), or translate your own on our website

The jOOQ User Manual : SQL building : Column expressions : String functions : REPEAT

previous : next