No Dual Required
September 20, 2007
Two corollaries to yesterday’s post.
1. The Dual table becomes redundant, because now
where X = 1
Question: how does the query execution engine figure out the type of the variable X?
2. Integer generator query:
where X < 100
No level, rownum, or connect by!