Subversion Repositories DevTools

Rev

Rev 13 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed 

/* Project List */
SELECT dmp.PROJ_ID,
           dmp.PROJ_NAME,
           dmp.RM_PROJECTS_FK,
           proj.PROJ_NAME AS RM_PROJECT_NAME,
           dmp.IS_HIDDEN,
           dmp.IS_DOWNLOAD
  FROM DM_PROJECTS dmp,
           PROJECTS proj
 WHERE dmp.RM_PROJECTS_FK = proj.PROJ_ID (+)
 ORDER BY UPPER(dmp.PROJ_NAME)