Will SQL charset wildcard query work on Oracle database? I am trying to run the following query

SELECT * FROM GEEKYBRAINS.admin_emp where ename like '[sm]%';


It results in an empty set.

The admin_emp table has the following data though.



I am running this on Oracle database. Will the charset wildcard search work with Oracle database ?
Use regexp_like:

select ename
from admin_emp
where regexp_like(ename,'(^[sm])');


Example SQL Fiddle here.