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)
/

Back

  1271