Wildcard Operators are similar to LIKE clause operations. And these LIKE clause permits some special cases to be utilized as a part of WHERE clause such as INSERT, DELETE, SELECT and UPDATE proclamation. SQL Like clause also permits execution of design coordination.

By viewing the below example, the concept of Wildcard Operators can be easily understood. [c] sql> select * from employee21; +--------+-------+-------+--------+-----------+ | emp_id | ename | sal | deptno | job | +--------+-------+-------+--------+-----------+ | 1001 | mike | 12000 | 10 | manager | | 1002 | rambo | 13000 | 20 | scalesman | | 1003 | kate | 14000 | 10 | manager | | 1003 | jeo | 14000 | 20 | manager | | 1003 | finn | 14000 | 30 | manager | +--------+-------+-------+--------+-----------+ 5 rows in set (0.00 sec) sql> select * from employee21 where ename like '%bo'; +--------+-------+-------+--------+-----------+ | emp_id | ename | sal | deptno | job | +--------+-------+-------+--------+-----------+ | 1002 | rambo | 13000 | 20 | scalesman | +--------+-------+-------+--------+-----------+ 1 row in set (0.10 sec)[/c] Here in the above example, the Like clause will permit to match any string of length characters.

• Wildcard Operators - Wildcard operations are similar to Like operators.