Subversion Repositories DevTools

Rev

Rev 119 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
/* Projects Combo */
2 
SELECT proj.PROJ_ID,
3 
	   proj.PROJ_NAME,
4 
	   DECODE ( :PROJ_ID,
5 
	   			proj.PROJ_ID, 'selected',
6 
				NULL ) AS SELECTED
7 
  FROM PROJECTS proj
8 
 ORDER BY UPPER(proj.PROJ_NAME)