Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Select last_name from employees where
- Last_name like '%a%' and
- Last_name like '%e%' and
- Last_name like '%s%' ;
- regexp_like(last_name, '(.*a.*b.*c.*)|(.*a.*c.*b.*)|(.*b.*a.*c.*)|(.*b.*c.*a.*)|(.*c.*a.*b.*)|(.*c.*b.*a.*)')
- ^(?=.*a)(?=.*b)(?=.*c)
- regexp_like(Last_name, 'a') and
- regexp_like(Last_name, 'e') and
- regexp_like(Last_name, 's')
Add Comment
Please, Sign In to add comment