eTL SUM and Group by fail with error: 'Can't select both scalar values and aggregate functions.'
Last updated on OCTOBER 16, 2007
Applies to:Oracle Java CAPS Core - Version: 5.1.1 and later
Information in this document applies to any platform.
5.1.1 eTL editor is giving the following error when using sum and group by clauses. The error complains that you can not select both scalar vlaues and aggregate functions.
Test execution failed: Invalid eTL Collaboration.
Can't select both scalar values and aggregate functions.
To verify if there is a problem in SQL, it was executed against oracle using SQL PLUS. It works fine.
SQL> select 'Department:'||dname dname, sum(sal) from emp, dept where emp.deptno=dept.deptno group by dname;
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms