Hello, It looks like I have just discovered XOR is not an SQL keyword. While I have no trouble coding it the long way with ANDs and ORs if necessary, is there no XOR keyword equivalent to make this tidier? Thanks, Jason

Re: No XOR? What, exactly, are you attempting to implement? The UTL_RAW package offers BIT_XOR which can be used with raw values; the SDO_GEOM package offers SDO_XOR for spatial geometry objects. A bit of explanation is in order here to understand what you're doing and whether or not either of those packaged offerings will help.

Re: No XOR? Ah, well, really it was simply something like the below. Just a quick test: Code (SQL): ... AND ( A.Q_ID IN ( 1,2,3,4 ) XOR B.Q_ID IN ( 1,2,3,4 ) ) ...

Re: No XOR? There is no 'pure' XOR conditional in Oracle, or in the SQL Standard if I remember correctly, therefore implementing the above will require you to either a) write your own XOR function and overload it to take numeric values, string values, numeric value lists or string value lists b) do this the 'old fashioned way' and code it with ANDs and ORs

Re: No XOR? If you choose the function route you'll have it for later implementations and won't need to rewrite the code over and over again whenever you need it.