Guest User

Untitled

a guest
Jun 22nd, 2018
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. Select last_name from employees where
  2. Last_name like '%a%' and
  3. Last_name like '%e%' and
  4. Last_name like '%s%' ;
  5.  
  6. regexp_like(last_name, '(.*a.*b.*c.*)|(.*a.*c.*b.*)|(.*b.*a.*c.*)|(.*b.*c.*a.*)|(.*c.*a.*b.*)|(.*c.*b.*a.*)')
  7.  
  8. ^(?=.*a)(?=.*b)(?=.*c)
  9.  
  10. regexp_like(Last_name, 'a') and
  11. regexp_like(Last_name, 'e') and
  12. regexp_like(Last_name, 's')
Add Comment
Please, Sign In to add comment