When you don’t know what value you need to search then you can use the like operator in where cluse.
Symbols with like.
(%) represents any number of characters
(_) the underscore symbol represents a single character.
The search string is enclosed in single quotation marks.sql wildcard
Examples
Select ename,job
From emp
Where ename like ‘c%’;
Ename job
---------- ---------
Clark manager
Select ename,job
From emp
Where ename like ‘s%’;
Ename job
---------- ---------
Smith clerk
Scott analyst
Sql> select ename
2 from emp
3 where ename like '_a%';
Ename
----------
Ward
Martin
James
The result is a list of employee names .each name includes the letter a as the second letter in the name.
Posts
