Go to most recent revision | Details | Last modification | View Log | RSS feed
/* Projects Combo */
SELECT proj.PROJ_ID,
proj.PROJ_NAME,
DECODE ( :PROJ_ID,
proj.PROJ_ID, 'selected',
NULL ) AS SELECTED
FROM PROJECTS proj
ORDER BY UPPER(proj.PROJ_NAME)