Orcale SQL Tutorial
Loading...
Not condition
ORACLE NOT condition
In Oracle, NOT condition is used with SELECT, INSERT, UPDATE or DELETE statement. It is also called NOT operator. It is used to negate the given condition.
Syntax
- NOT condition
Parameters
Condition: condition to be neglected.
Table:
Example 1
Query: select *from table1 where name not like 26 |
Example 2
Query: select *from table1 where name not like 's%' |