Hi
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
FROM ReferralView
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
Please update
Thank you
Surya
20081119-EE-VQP-45 - Hierarchy / EE_QW_2_20070628