This content has been marked as final. Show 8 replies
Not sure what I am missing here in my Sql Statement. I keep getting the [Error] Execution: (ORA-00907: missing right parenthesis error
IF(detail.Order_Type = 'FOR','1','2') as FOR_TYPE_ID,
from BACKLOG_WEEKLY_FACT_MV fact,
where fact.TRANSACTION_ID = detail.BACKLOG_HISTORY_ID;
Any help will be appreciated.
Thanks in advance,