Home » SQL & PL/SQL » SQL & PL/SQL » error 00920 ??
error 00920 ?? [message #251662] Mon, 16 July 2007 00:15 Go to next message
b_garima
Messages: 1
Registered: July 2007
Junior Member
Hi

While executing this query 'm getting error for invalid relation operator( error 00920)

select count(*) as AUDIO from cdr WHERE VASPKEYWORD = 'VASP04' and ISMOBILEORIG = 1 and timestamp between 1184052829 and 1184055725 and MSGTYPE=1 OR MSGTYPE=2 OR MSGTYPE=3 OR MSGTYPE=7 OR MSGTYPE=8 and (CONTENTTYPE LIKE '%006%' OR CONTENTTYPE LIKE '%007%' OR CONTENTTYPE LIKE '%008%' OR CONTENTTYPE LIKE '%009%' OR CONTENTTYPE LIKE '%010%' OR CONTENTTYPE LIKE '%011%' OR CONTENTTYPE LIKE '%012%' OR CONTENTTYPE LIKE '%013%' OR CONTENTTYPE LIKE '%014%' OR CONTENTTYPE LIKE '%015%') and CONTENTTYPE NOT LIKE '%001%' and CONTENTTYPE NOT LIKE '%002%' and CONTENTTYPE NOT LIKE '%003%' and CONTENTTYPE NOT LIKE '%004%' and CONTENTTYPE NOT LIKE '%005%' and CONTENTTYPE NOT LIKE '%016%' and CONTENTTYPE NOT LIKE '%017%' and CONTENTTYPE NOT LIKE '%018%' and CONTENTTYPE NOT LIKE '%019%' and CONTENTTYPE NOT LIKE '%020%' and CONTENTTYPE NOT LIKE '%021%' and CONTENTTYPE NOT LIKE '%022%' and CONTENTTYPE NOT LIKE '%023%' and CONTENTTYPE NOT LIKE '%024%' and CONTENTTYPE NOT LIKE '%025%' and CONTENTTYPE NOT LIKE '%027%' and CONTENTTYPE NOT LIKE '%028%' and CONTENTTYPE NOT LIKE '%029%' and CONTENTTYPE NOT LIKE '%030%' and CONTENTTYPE NOT LIKE '%031%' and CONTENTTYPE NOT LIKE '%032%' and CONTENTTYPE NOT LIKE '%033%' and CONTENTTYPE NOT LIKE '%034%' and CONTENTTYPE NOT LIKE '%035%' and CONTENTTYPE NOT LIKE '%036%' and CONTENTTYPE NOT LIKE '%037%' and CONTENTTYPE NOT LIKE '%038%' and CONTENTTYPE NOT LIKE '%039%' and CONTENTTYPE NOT LIKE '%044%' and CONTENTTYPE NOT LIKE '%045%' and CONTENTTYPE NOT LIKE '%099%'


Thanks in advance
Regards
Garima
Re: error 00920 ?? [message #251666 is a reply to message #251662] Mon, 16 July 2007 00:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read and follow How to format your posts and How to get a quick answer to your question: TIPS AND TRICKS
Make sure that lines of code do not exceed 80 or 100 characters when you format.
Please always post your Oracle version (4 decimals).

Regards
Michel
Re: error 00920 ?? [message #251806 is a reply to message #251662] Mon, 16 July 2007 13:09 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Since you don't nest your or's on the messagetype in braces, your query will return the wrong results.
Syntactically your query looks ok.
Show a sqlplus copy-paste where it fails. Make sure you also copy the part where the error is shown.
Previous Topic: Loops ....
Next Topic: can we create a trigger on one column
Goto Forum:
  


Current Time: Fri Dec 09 19:09:00 CST 2016

Total time taken to generate the page: 0.10354 seconds