Simple SQL Query Fails When Configuring The OIC Oracle Database Adapter But Runs Successfully in SQLPlus (Doc ID 2663145.1)

Last updated on DECEMBER 03, 2022

Applies to:

Goal

Why does the simple sql query:

 select column, sum(number)
  from table

complete successfully, but when adding a 'group by' clause

  select column, sum(number)
   from table
  group by column

returns the database error ORA 00933: SQL command not properly ended error?
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.