SQL Modeling
SELECT val, msg FROM DUAL |
MODEL |
DIMENSION BY (0 d) |
MEASURES (CAST('m' AS VARCHAR2(30)) msg, 0 as val) |
RULES ITERATE (5) |
(msg [iteration_number] = 'Have A Great Day -> '||TO_CHAR(SYSDATE,'mm/dd/yyyy'), |
val [iteration_number] = iteration_number+1) |
/ |
72702