Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-00920 invalid relational operator

Re: ORA-00920 invalid relational operator

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 04 Jul 2005 06:51:11 -0700
Message-ID: <1120485087.807048@yasure>


HansF wrote:
> On Mon, 04 Jul 2005 06:01:07 -0700, olivier.duhart interested us by
> writing:
>
>
>

>>[e.region||'.'||e.subregion||'.'||e.holding LIKE '%.24.%'] part but I

>
>
> First stab ... I know it's a slightly different query, but ... from a
> business view rather than pure technical, how does the above differ from
>
> e.subregion='24'
>
> (assuming region and holding do not contain '.')

On the same track but far clearer thinking than mine. I'll get some coffee and try for some artificial intelligence. ;-)

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon Jul 04 2005 - 08:51:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US