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%’
Leave a Reply