Re: Select enumeration of intergers

paul c wrote:
> I saw some comments about this at
> http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:948366252775
> which fascinated me, along the lines of "the definition is whatever
> the implementation does" (my words). No wonder there is a market for
> people who explain these products. Some years since I knew any SQL but
> I got a kick out of the exchange where Mikito said that UNION should be
> identical to OR and the Oracle 'oracle' gave an example where it's not.
> This seemed to depend on SQL tables allowing duplicate rows.

Obviously, Mikito made a typo and he meant

"select distinct from T where A or B

is identical to

select from T where A
union
select from T where B"

It is also clear that Tom was more interested explaining SQL quirks, rather than exploring what the ideal SQL design should be.

BTW, the syntax in my message works while substituting rownum with level, rendering this whole rownum discussion as not relevant. Received on Fri Jul 07 2006 - 21:25:25 CEST