ORA-00937 when creating a table in SQL Navigator (4335226)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

ORA-00937 when creating a table in SQL Navigator
Description

Getting the error "ORA-00937 - not a single-group group function" when creating a table in SQL Navigator.
It is possible to create the table in SQL Plus.
To reproduce the problem please follow the steps below:

create table test_table(
col1 number,
col2 number,
col3 number)
create table no_x111 nologging as
select case when col1 is not null then col1 else col2 end as col2, sum(col3) as col3
from test_table where col2=1
group by case when col1 is not null then col1 else col2 end;
Cause

This is an issue with the SQL parser of SQL Navigator. It cuts off the create table statement incorrectly and results the ORA-00937 error when executing.
Resolution

WORKAROUND

Remove the last semicolon from the statement and then execute it.

STATUS

Waiting for fix in a future release of SQL Navigator for Oracle
Defect ID

CR 12813

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title