Subversion Repositories DevTools

/* User Applications */
SELECT ap.APP_ID,
           ap.APPLICATION_NAME
  FROM USER_APPLICATIONS ua,
           APPLICATIONS ap
 WHERE ua.APP_ID = ap.APP_ID
   AND ua.USER_ID = :USER_ID
 ORDER BY UPPER(ap.APPLICATION_NAME)