Please note this query is resulting an output in Oracle 10G but the same is not working with Oracle 9i
SELECT ProviderName, ProviderID, Count(ProviderID) AS NumOfReferrals, MAX(SubmitDate) AS MaxDate
GROUP BY ProviderName, ProviderID;
I am given the below error trying to execute this query from the sql prompt and the session gets terminated.
ERROR at line 1:
ORA-03113: end-of-file on communication channel