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)[07/SRC/B1160, 06/IN.1/I85]; Intel Ireland is acknowledged under the Irish Research Council for Science, Engineering and Technology (IRCSET) embark initiative for CO'S; Rish Government') ORA-00907: missing right parenthesis