Advertisement

11.17.2008 at 04:39PM PST, ID: 23912846 | Points: 500
[x]
Attachment Details

CAN WE USE MUTIPLE GROUP FUNCTIONS IN ORACLE 9I

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
 
 
 
Expert Comment by sujith80:

All comments and solutions are available to Premium Service Members only. Start your 7-day free trial to view the solution to this question.

Already a member? Login to view this solution.

 
 
Expert Comment by SJT2003A:

All comments and solutions are available to Premium Service Members only. Start your 7-day free trial to view the solution to this question.

Already a member? Login to view this solution.

 
 
Expert Comment by SJT2003A:

All comments and solutions are available to Premium Service Members only. Start your 7-day free trial to view the solution to this question.

Already a member? Login to view this solution.

 
 
Expert Comment by sujith80:

All comments and solutions are available to Premium Service Members only. Start your 7-day free trial to view the solution to this question.

Already a member? Login to view this solution.

 
 
Expert Comment by nav_kum_v:

All comments and solutions are available to Premium Service Members only. Start your 7-day free trial to view the solution to this question.

Already a member? Login to view this solution.

 
 
20081119-EE-VQP-45 - Hierarchy / EE_QW_2_20070628