LOOPING SQL

From: Dang <mdang_at_bigpond.com.au>
Date: Thu, 12 Feb 2004 12:32:32 +1100
Message-ID: <c0el3f$9n6$1@mws-stat-syd.cdn.telstra.com.au>

I am running Oracle 8i and trying to run a Loop of SQL based on one number. Problem is this number can vary.

Example:
How to convert this SQL into one Statement SQL based on LOOP

SELECT SYSDATE, LOOP FROM
(SELECT SYSDATE, '1' AS LOOP FROM dual
UNION
SELECT SYSDATE, '2' AS LOOP FROM dual
UNION
SELECT SYSDATE, '3' AS LOOP FROM dual
UNION
SELECT SYSDATE, '4' AS LOOP FROM dual
UNION
SELECT SYSDATE, '5' AS LOOP FROM dual
)

Result

SYSDATE                          LOOP
12/02/2004 12:28:32 pm 1
12/02/2004 12:28:32 pm 2
12/02/2004 12:28:32 pm 3

12/02/2004 12:28:32 pm 4
12/02/2004 12:28:32 pm 5 Received on Wed Feb 11 2004 - 19:32:32 CST