All errors › ORA errors
ORA-00928: Missing SELECT keyword
What it means
A subquery or CREATE VIEW ... AS / INSERT ... with column list is not followed by SELECT where one is required (often a WITH clause placed wrongly).
How to fix it
Check that the WITH clause sits directly before the SELECT it belongs to, and that CREATE VIEW ... AS and INSERT INTO t (cols) are followed by a query.
Catch it before it runs
ORA Error Helper
Explains ORA-/PLS- codes inside JetBrains IDEs and DataGrip. PL/SQL Lint
Flags risky PL/SQL patterns while you type. Oracle Plan Reader
Reads execution plans and points at the slow step. PL/SQL in Practice
Kindle book with practical PL/SQL for working developers.
Explains ORA-/PLS- codes inside JetBrains IDEs and DataGrip. PL/SQL Lint
Flags risky PL/SQL patterns while you type. Oracle Plan Reader
Reads execution plans and points at the slow step. PL/SQL in Practice
Kindle book with practical PL/SQL for working developers.
Nearby errors
Updated 2026-11-12.