Search notes:

ORA-00905: missing keyword

In the following SQL statement, the parser expects the keyword end after 'n/a' but does not encounter it, so in Oracle releases prior to 23c, the error message ORA-00905: missing keyword is thrown.
select
   case when owner in ('SYS', 'SYSTEM') then 'n/a'
from
   dba_tables;
In 23c or later, Oracle specifed the expected keyword, for example ORA-02000: missing END keyword.

INTO clause / Copy paste from PL/SQL

The ORA-00905 error is thrown, for example, when copying an select statement from PL/SQL without removing the into clause:
select
   col_1
into
   var_1
from
   tab_A;

Misc

select
    *
from
   dual
pivot(max(dummy));

See also

Other Oracle error messages such as ORA-02000: missing … keyword

Index