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 specified 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

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1758206416, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/errors/ORA-00905_missing-keyword(62): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78