How to Fix ORA-00933: SQL Command Not Properly Ended in Oracle
Fix statements Oracle reads as finished too early, and understand the ORA-03048 and ORA-03049 messages 26ai shows instead.
AI-Assisted
Posts tagged AI-Assisted are created with support from artificial intelligence. I use AI tools to research, draft, and refine ideas—combining human insight with machine precision to deliver clear, informed, and creative content.
How to Fix ORA-00923: FROM Keyword Not Found Where Expected in Oracle
Find what ended the select list too early in ORA-00923: a missing comma, a reserved word as alias, or SELECT TOP.
How to Fix ORA-00918: Column Ambiguously Defined in Oracle
Tell Oracle which table a shared column name belongs to, with table aliases or a join with USING, and fix ORA-00918.
How to Fix ORA-00917: Missing Comma in Oracle
Find the missing comma in an INSERT column list or VALUES list from the position in the ORA-00917 error.
How to Fix ORA-00911: Invalid Character in Oracle
Find the character behind ORA-00911, often syntax from MySQL or JDBC, and rewrite it the Oracle way.
How to Fix ORA-00907: Missing Right Parenthesis in Oracle
Use the error position to find where Oracle expected a closing parenthesis, and fix unbalanced lists and subqueries.
How to Fix ORA-00904: Invalid Identifier in Oracle
Find the name Oracle cannot resolve in ORA-00904 and fix typos, case-sensitive quoted columns, and misplaced aliases.
How to Fix ORA-00001: Unique Constraint Violated in Oracle
Find which constraint, column, and value caused ORA-00001, and load data without duplicates using MERGE or NOT EXISTS.
How to Debug ORDS Errors
Trace a generic ORDS 555 error to the Oracle error behind it, through the ORDS log or debug output, and know the common status codes.
How to Use ETags for Optimistic Locking in ORDS
Stop REST clients from overwriting each other's changes with ETags and If-Match, and skip unchanged responses with 304.
How to Export and Import ORDS Modules
Move ORDS REST modules between databases as scripts with SQLcl or ORDS_EXPORT, and restore a deleted module from its export.
How to Publish JSON Duality Views through ORDS
Turn a JSON relational duality view into a document REST API with ORDS, with updates and built-in conflict detection.
How to Generate OpenAPI Documentation for ORDS Modules
Use the OpenAPI documents ORDS generates for your REST modules, add good descriptions, and view them in Swagger UI.
How to Run SQL over HTTP with REST-Enabled SQL
Send SQL to ORDS over HTTP and get JSON results, with bind variables and scripts, using an OAuth client instead of a password.
How to Run Code Before Every Request with an ORDS Pre-Hook
Run one PL/SQL function before every ORDS REST call to log requests and refuse them during maintenance.
How to Enable CORS for ORDS APIs
Let web applications on other origins call your ORDS APIs, restrict a module to the origins you trust, and test preflights.
How to Manage OAuth Clients and Roles in ORDS
Keep ORDS OAuth clients under control: shorter tokens, rotated secrets, revoked roles, and deleted clients.
How to Secure ORDS APIs with OAuth2 Client Credentials
Let other systems call protected ORDS APIs with an OAuth2 client ID, secret, and short-lived access token.