String

REPEAT

Snowflake

Mengulangi string sejumlah count kali. Berguna untuk membuat pola atau separator.

Tipe hasil: VARCHARDiperbarui: 6 Jan 2026

Syntax

SQL

REPEAT(string, count)

stringVARCHARwajib

String yang akan diulang

countINTEGERwajib

Jumlah pengulangan

SQL

1 SELECT REPEAT('-', 50) as separator;

Membuat garis 50 karakter dash.

Hasil

--------------------------------------------------

SQL

1 SELECT
2   level,
3   REPEAT('  ', level) || name as indented_name
4 FROM hierarchy;

Membuat indentasi berdasarkan level di hierarchy.

Hasil

SQL

1 SELECT
2   task_name,
3   progress_pct,
4   REPEAT('█', progress_pct / 10) || REPEAT('░', 10 - progress_pct / 10) as progress_bar
5 FROM tasks;

Membuat visual progress bar dengan Unicode characters.

Hasil

TASK_NAME	PROGRESS_PCT	PROGRESS_BAR
Task A	70	███████░░░
Task B	30	███░░░░░░░

1	SELECT
2	level,
3	REPEAT(' ', level) \|\| name as indented_name
4	FROM hierarchy;

1	SELECT
2	task_name,
3	progress_pct,
4	REPEAT('█', progress_pct / 10) \|\| REPEAT('░', 10 - progress_pct / 10) as progress_bar
5	FROM tasks;