Search notes:

SQLcl: REPEAT

repeat executes a statement multiple times, similar to the shell command watch.

SQL> select to_char(sysdate, 'hh24:mi:ss') from dual;
TO_CHAR(SYSDATE,'HH24:MI:SS')
________________________________
15:27:46

SQL> repeat 10 3

See also