Re: Oracle SQL engine?

A copy of this was sent to Norris <johnnie_at_cooper.com.hk> (if that email address didn't require changing) On 3 Aug 1999 13:58:50 GMT, you wrote:

>Can anybody tell me the differences between the following two SQL?
>
>select a.* , dummy from dual a
>/
>select * , dummy from dual a
>/

the first one is correct and works.

the second one is not correct and fails.

you can "select * from ...." -- if * is alone it need not be qualified.

if you select another column (real column or derived column) -- then * needs a qualifier -- it must be associated with a table/correlation name in the FROM clause.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Aug 03 1999 - 11:17:22 CDT