Search notes:
ORA-02000: missing … keyword
In
Oracle 23c
or later, the following statement throws
ORA-02000: missing END keyword
because the
case when
expression is not terminated with
end
:
select case when owner in ('SYS', 'SYSTEM') then 'n/a' from dba_tables;
In Releases prior to 23c, Oracle throws
ORA-00905: missing keyword
.
See also
Other Oracle error messages
Index