How to fix ora 00937 not a single group group function?
Drop either the group function or the individual column expression from the SELECT list or add a GROUP BY clause that includes all individual column expressions listed. To learn more about ways we can support your database visit our Oracle database consultancy page. Lees verder »
Bron: xynomix.com
What does ora 00937 not a single group group function mean?
Cause. A SELECT list cannot include both a group function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, and an individual column expression, unless the individual column expression was included in a GROUP BY clause. Lees verder »
Bron: docs.oracle.com
How to resolve ora error?
- Use AHF to generate an ORA-00600 Service Request Data Collection (SRDC)
- Use ORA-00600 Troubleshooting Tool to find recommendations.
- Log a new SR using the diagnostic collection.
- Lees verder »
Bron: docs.oracle.com
How to solve tns problem in Oracle?
- Check for mistakes in the connection string that you used.
- If you have a sqlnet. ...
- If you are using an alias from a tnsnames. ...
- Verify that the tnsnames. ...
- Ensure that the alias exists in one of the tnsnames. ...
- Ensure that there are no syntax errors anywhere in the tnsnames. ...
- If you are using LDAP directory naming:
- Lees verder »
Bron: docs.oracle.com
Gerelateerd aan How to fix ora 00937 not a single group group function?