Re: Using "SOME" in a subselect
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: Mark.McNary@xxxxxxx
- Date: Thu, 18 Dec 2008 09:56:33 -0800
Any idea as to what the advantage of SOME/ANY is over other forms?
AND p.refreshTimeStamp = SOME
(SELECT
MAX(pa.refreshTimeStamp)
FROM pymt pa
WHERE compid = '12345666'
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
On Thu, Dec 18, 2008 at 9:41 AM, McNary, Mark <Mark.McNary@xxxxxxx> wrote:
> I found this in the 10g dox
>
>
> http://download-uk.oracle.com/docs/cd/B14117_01/server.101/b10759/conditions002.htm#sthref888
>
>
>
> Thanx,
>
>
>
> <-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
>
> *-Mark McNary*
>
> -SENIOR DATABASE ADMINISTRATOR
>
> UMB Bank, n.a.
>
> 1008 Oak St.
>
> MS1170304
>
> Kansas City MO 64106
>
> (816)860-1934(W)
>
> (816)213-3125(M)
>
> (816) 860-1774(F)
>
> mark.mcnary@xxxxxxx
>
> http://www.umb.com
>
> "We are the music makers. We are the dreamers of dreams" ~Willy Wonka
> <-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
>
>
>
> -----Original Message-----
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Sandra Becker
> *Sent:* Thursday, December 18, 2008 11:12 AM
> *To:* oracle-l
> *Subject:* Using "SOME" in a subselect
>
>
>
> I came across some code today that has the following:
>
> SELECT
>
> .
>
> .
>
> .
>
> WHERE
>
> .
>
> .
>
> .
>
> AND p.refreshTimeStamp = SOME
> (SELECT
> MAX(pa.refreshTimeStamp)
> FROM pymt pa
> WHERE compid = '12345666'
>
>
>
> Can anyone tell me what the " = SOME" portion of the code does? I've done
> some research, but can't find anything so far.
> --
> Sandy
> Transzap, Inc.
>
> ------------------------------------------------------------------------------
> NOTICE: This electronic mail message and any attached files are
> confidential. The information is exclusively for the use of the individual
> or entity intended as the recipient. If you are not the intended recipient,
> any use, copying, printing, reviewing, retention, disclosure, distribution or
> forwarding of the message or any attached file is not authorized and is
> strictly prohibited. If you have received this electronic mail message in
> error, please advise the sender by reply electronic mail immediately and
> permanently delete the original transmission, any attachments and any copies
> of this message from your computer system. Thank you.
>
> ==============================================================================
>
>
Other related posts:
