regexp_like in oracle example
Example 1: regexp_like in oracle example
SELECT *
FROM names
WHERE regexp_like (name , 'z') ;
-- Oracle REGEXP_LIKE example would
--retrieve all of the names that contain the letter ‘z’.
NAME
-------------------------
Lorentz
Gietz
Example 2: regexp_like oracle c++
WHERE REGEXP_LIKE(first_name, '^Ste(v|ph)en$')