60

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

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%’