SQL

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

Not REGEXP_LIKE in Oracle

select *
from users 
where not regexp_like(phone_number, '^+[0-9]{9,13}$')