ORA-00907: missing right parenthesis - select description from (SELECT NULL OBJECT_ID, ' -- Select Funding Body -- ' DESCRIPTION FROM DUAL UNION SELECT OBJECT_ID, BODY_NAME DESCRIPTION FROM VA_FUNDING_BODY WHERE SYSDATE BETWEEN START_DATE AND NVL(END_DATE, SYSDATE+1) ORDER BY 2) where object_id in ('Science Foundation Ireland (SFI)[06/IN.1/185]; Irish Research Council for Science, Engineering and Technology (IRCSET); Irish Government's Programme for Research in Third Level Institutions, Cycle 4, National Development Plan 2007-2013') ORA-00907: missing right parenthesis