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: HansF <News.Hans_at_telus.net>
Date: Mon, 04 Jul 2005 13:28:03 GMT
Message-ID: <pan.2005.07.04.13.31.28.253600@telus.net>


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 '.')

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***
Received on Mon Jul 04 2005 - 08:28:03 CDT

Original text of this message

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