Re: Does Oracle implement 'Any' and 'All' op codes?

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Fri, 03 Oct 2003 14:45:22 GMT
Message-ID: <3F7D88EC.7651787F@yahoo.net>

Ryan Gaffuri wrote:

> Im reading an academic DB book that covers that SQL Standard(to a
> lesser extent).
>

Not-so-gentle reminder .... Since you are a reader, Oracle also has books, many of them free and available at http://docs.oracle.com <g>

>
> The standard has a couple of op codes. I know how to write this code
> in Oracle without using them and I cant find them in the
> documentation(maybe its buried somewhere)...
>
> Such as:
>
> Select Person
> From Person_table
> where person_height > ANY (Select Height
> from Blocks
> )
>
> It means select all 'person' who are taller than ANY block. Its the
> same thing as using a 'least' function. There is also 'all', which
> would be implemented with 'max'.
>
> Im just curious. Its not really essential to anything.

Check out the "Oracle7 Server SQL Reference, Release 7.3" page 3-79 (online at http://otn.oracle.com/documentation/oracle7.html). ANY, ALL & SOME were implemented a long time ago! Received on Fri Oct 03 2003 - 09:45:22 CDT