No Dual Required

September 20, 2007

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!


4 Responses to “No Dual Required”

  1. Sokrates Says:


    what are you talking about ?
    which database vendor + version allows these queries ?

    Thank you

  2. This is just a proposal.

  3. Sokrates Says:

    you have my support for this

  4. […] consequence of this amendment is that the famous Dual table is no longer required. The other implication of equating tables with predicates is that physical query optimization can […]

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: