daily pastebin goal
65%
SHARE
TWEET

Untitled

a guest Mar 13th, 2018 58 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Select tab_users.USER
  2.  from tab_users , tab_grants , tab_roles r
  3.   where tab_users.user_id = tab_grants.user_id(+)
  4.         and tab_grants.role_id = tab_roles.role_id(+)
  5. group by tab_users.USER
  6.  having sum(decode(tab_roles.name,'Техподдержка',1,0)) = 0
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top