plsql not equal

Solutions on MaxInterview for plsql not equal by the best coders in the world

showing results for - "plsql not equal"
Mirko
11 Jan 2017
1SELECT 1 FROM dual
2WHERE 1 != 2
3OR    1 <> 2;
4-- WARNING: the not equal operators do NOT check for NULL value:
5-- myTable: ID(CHAR) | flag(NUMBER)
6-- 			A			1
7-- 			B			0
8-- 			C			NULL
9
10SELECT ID FROM myTable t
11WHERE t.flag != 1;
12-- returns B
13
14SELECT ID FROM myTable t
15WHERE t.flag != 1 OR t.flag IS NULL;
16-- returns B and C
17
18
similar questions
queries leading to this page
plsql not equal