In oracle, like condition is used with select, insert, update, and delete in where clause using wildcard. It allows pattern matching.
expression LIKE pattern [ESCAPE 'escape_character' ]
expression: name of column.
pattern: patter to be matched in expression. Pattern can be in one of the following:-
|%||Used for matching string|
|_||Used for matching single character|
Query: select * from table1 where name like 's%'
Query: select * from table1 where name like '22___'
Query: select * from table1 where name NOT like 's%'