ORA-00928 missing SELECT keyword
What causes an ORA-00928 error?
A SELECT subquery must be included in a CREATE VIEW statement.
How Xynomix can help
Correct the syntax. Insert the required SELECT clause after the CREATE VIEW clause and then retry the statement.
Contact us for more information. To learn more about ways we can support your database visit our Oracle database consultancy page.
On submitting this form, Xynomix will store your details and may contact you in relation to your request. For more information on how we process data, please see our privacy notice.