Need a unique gift idea?
A Pastebin account makes a great Christmas gift
SHARE
TWEET

Untitled

a guest Mar 13th, 2018 58 Never
Upgrade to PRO!
ENDING IN00days00hours00mins00secs
 
  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