Generate Values

View All Scripts Login to Run Script

Script Name Generate Values
Description Generate a series of Values with an SQL statement and without real data.
Area SQL General / SQL Query
Contributor Daniel Nelle
Created Friday May 05, 2017

Statement 1

SELECT level FROM dual CONNECT BY level <= 7


LEVEL
1
2
3
4
5
6
7

7 rows selected.

Statement 2

SELECT TRUNC(SYSDATE-level+1) some_date FROM dual CONNECT BY level <= 7


SOME_DATE
05-MAY-17
04-MAY-17
03-MAY-17
02-MAY-17
01-MAY-17
30-APR-17
29-APR-17

7 rows selected.

Additional Information