DUAL table useful, for example, to generate sequence of numbers, like this:
SELECT level as ID
FROM DUAL
CONNECT BY level < 101
Will give you seqence of numbers 1..100
Type: Posts; User: Mad Hatter; Keyword(s):
DUAL table useful, for example, to generate sequence of numbers, like this:
SELECT level as ID
FROM DUAL
CONNECT BY level < 101
Will give you seqence of numbers 1..100