I am getting the following syntax error when I am trying to run my Query:
3707 Syntax error,expected something like a '"||"'or a 'FROM' keyword between a string or a Unicode character literal and the integer '20132014'.
I have narrowed down the error to the following portion of the WHERE clause in the SQL:
a11.BRDCAST_QTR_ID in (SELECT BRDCAST_QUARTER_ID FROM CALENDAR_BROADCAST_QUARTER WHERE BRDCAST_YEAR_ID = (substring('a11.DEAL_YEAR_CD in ('20132014')' from POSITION('(' IN 'a11.DEAL_YEAR_CD in ('20132014')') + 1 for 8) ))
you might want to put double '' around 20132014, so that you include the whole a11.DEAL_YEAR_CD in ('20132014') string inside a character literal (if that is what you are trying to achieve).
The following query is thorwing an error 3707 Syntax error,expected something like a name or a unicode delimited identifier or an UDFCALLNAME Keyword between ) and ;
Are you an Oracle user? :-)
You need to add an alias name before the final ";".