Subversion Repositories DevTools

/* User Role List */
SELECT ro.role_id,
           ro.ROLE_NAME,
           ro.COMMENTS
  FROM (
                
                SELECT ro.*
                  FROM ROLES ro
                 WHERE ro.APP_ID = :APP_ID
                
                MINUS
                
                SELECT ro.*
                  FROM ROLES ro,
                       USER_ROLES ur
                 WHERE ro.APP_ID = :APP_ID
                   AND ur.USER_ID = :USER_ID
                   AND ur.ROLE_ID = ro.ROLE_ID
                
                ) ro
 WHERE ro.IS_ROLE_VARIATION IS NULL
   AND ro.app_id = :APP_ID
ORDER BY UPPER(ro.role_name)