ORA-00933 sql command not properly ended select

Oracle error ORA-00933: SQL command not properly ended occurs when there is a syntax error in an SQL statement. This error often appears when a SQL command has incorrect formatting, an extra or missing clause, or misplaced keywords.

Common causes and solutions-

Extraneous characters at the end of the query

This error might occur if the SQL statement has unnecessary characters or punctuation at the end.

Example:

SELECT * FROM employees;

Incorrect:

SELECT * FROM employees,;  -- Extraneous comma

Solution: Remove the extra characters.

Missing or misplaced clauses (such as WHERE, ORDER BY, etc.):

Ensure that SQL clauses like WHERE, ORDER BY, etc., are correctly placed and formatted.

Example:

Incorrect:

SELECT * FROM employees ORDER BY;  -- Missing column after ORDER BY

Correct:

SELECT * FROM employees ORDER BY last_name;

Incorrect use of keywords:

Double-check that SQL keywords are correctly used and placed in the right order.

Example 

Incorrect:

SELECT FROM employees;  -- Missing column list

Correct:

SELECT * FROM employees;

Using JOIN without ON condition:

If you're using a JOIN, you must include the ON condition.

Incorrect:

SELECT * FROM employees JOIN departments;  -- Missing ON condition

Correct:

SELECT * FROM employees JOIN departments ON employees.department_id = departments.department_id;

Unbalanced parentheses or missing parentheses:

If you're using parentheses in your SQL queries, ensure they are balanced.

Incorrect:

SELECT * FROM employees WHERE (department_id = 10;  -- Missing closing parenthesis

Correct:

SELECT * FROM employees WHERE (department_id = 10);

 

Wrong placement of semicolons:

In Oracle SQL, a semicolon is used to terminate the statement. If you place it incorrectly within a query, you'll get this error.

Incorrect:

SELECT * FROM employees; WHERE employee_id = 101;  -- Wrong semicolon placement

Correct:

SELECT * FROM employees WHERE employee_id = 101;

INSERT, UPDATE, or DELETE commands improperly formatted:

Check that your INSERT, UPDATE, or DELETE statements have the correct format.

Incorrect:

INSERT INTO employees employee_id, first_name VALUES (101, 'John');  -- Missing parentheses around column names

Correct:

INSERT INTO employees (employee_id, first_name) VALUES (101, 'John');

By checking your SQL statement for any of these common mistakes and correcting them, you should be able to resolve the ORA-00933 error.