*/Wildcard

The asterisk (*) or so-called wildcard is used, for example, when selecting all or any data (or data sets) meeting a certain condition.

Example

SELECT * FROM EMPLOYEE
WHERE EMPLOYEE.PHONE_EXT='250';

All data sets containing the value 250 in the PHONE_EXT column in the EMPLOYEE table are fetched.