Help!!!!! The same statement is what the result is not the same???-CodePudding

The oracle database.
1. Query the select * from Scott. Emp where 5 - (select count (1) the from Scott. Dept where 1=0) & gt; 0 no results
2, the query select * from Scott. Emp where a 5-0 & gt; Fruitful 0
3. The query select * from Scott. Emp where (select count (1) the from Scott. Dept where 1=0)=0 results

The same statement in other oracle database performs no problem, have the result,

Thank god taught genuflect is begged to us,

CodePudding user response:

With doing this, or adding more parentheses

CodePudding user response:

1 - filter (TO_NUMBER (TO_CHAR (5 - (SELECT COUNT (*) FROM "SYS". "DUAL" DUAL "WHERE" NULL IS NOT NULL))) & gt; 0)
Guess (select count (1) from DUAL where 1=0) was TO_CHAR is NULL, the other parts will be forced to TO_CHAR (), arithmetic operations into a logic operations, specific why so will welcome bosses

CodePudding user response:

Put in front of the photo upload failed ~ ~ ~