ORACLE LIKE CONDITION

In oracle, like condition is used with select, insert, update, and delete in where clause using wildcard. It allows pattern matching.

Syntax

Parameters

expression: name of column.

pattern: patter to be matched in expression. Pattern can be in one of the following:-

Table 1:

Table 2:

Example 1

Query: select * from table1 where name like 's%'

Example 2

Query: select * from table1 where name like '22___'

Example 3

Query: select * from table1 where name NOT like 's%'