No Dual Required

Two corollaries to yesterday’s post.

1. The Dual table becomes redundant, because now

select X
where X = 1

is allowed.

Question: how does the query execution engine figure out the type of the variable X?

2. Integer generator query:

select X
where X < 100

No level, rownum, or connect by!