Re: Oracle SQL engine?

From: Peter Marksteiner <pm_at_univie.ac.at>
Date: 3 Aug 1999 16:20:36 GMT
Message-ID: <7o74sk$2s6e$1@www.univie.ac.at>

Norris <johnnie_at_cooper.com.hk> wrote:
: Can anybody tell me the differences between the following two SQL?

: select a.* , dummy from dual a
: select * , dummy from dual a

According to the syntax diagram of the SELECT statement (page 4-489 in the Oracle 8 SQL reference manual), "table.*" may occur as part of a comma-separated list, a lone "*" may occur only as "SELECT * FROM ...". Therefore the first statement is correct, the second isn't.

--
Peter Marksteiner
Vienna University Computer Center Received on Tue Aug 03 1999 - 11:20:36 CDT