... REGEXP_LIKE(S_SURNAME, '[^a-zA-Z0-9]')
-- returns all rows where the student surname contains non-alphanumeric characters
-- eg. O'Brien will be returned
SELECT * FROM STUDENTS WHERE REGEXP_LIKE(S_SURNAME, ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.