Javatpoint Logo
Javatpoint Logo

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:-

Wildcard Explanation
% Used for matching string
_ Used for matching single character

Table 1:

ORACLE LIKE CONDITION

Table 2:

ORACLE LIKE CONDITION

Example 1

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

ORACLE LIKE CONDITION

Example 2

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

ORACLE LIKE CONDITION

Example 3

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

ORACLE LIKE CONDITION
Next TopicMINUS




Youtube For Videos Join Our Youtube Channel: Join Now

Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA