Top "Ora-00933" questions

SQL command not properly ended.

SQL Command not properly ended?

I am using a SQL statement with a Temporary relation, and am getting the error ORA-009933: SQL command not properly …

Read More
sql oracle ora-00933 table-alias
Oracle: Order by Union returning ORA-00933: SQL command not properly ended

I have an issue with using Oracle's union and order by clauses together. I have two complex queries (with sub …

Read More
oracle sql-order-by union ora-00933
Error(2,7): PLS-00428: an INTO clause is expected in this SELECT statement

I'm trying to create this trigger and getting the following compiler errors: create or replace TRIGGER RESTAR_PLAZAS AFTER INSERT …

Read More
sql oracle triggers ora-00933 pls-00428
SQL Update a table based on join with anther table

I am trying to update a table by joining the values with another table. Here's my query so far. UPDATE …

Read More
sql oracle oracle10g ora-00933
Why does my query produce error "ORA-00933: SQL command not properly ended"?

My query: CREATE VIEW cambiodatos AS SELECT a.last_name||','||a.first_name AS "Nombre", a.salary AS "…

Read More
sql oracle ora-00933
ERROR at line 1: ORA-00933: SQL command not properly ended

i'm working on a request ,and i think i missed a clause because i having this error ERROR at line 1: …

Read More
sql oracle ora-00933
Why does this HQL delete fail, when an HQL select with same terms works?

Why does the following HQL query fail? string hql = @"delete MyLog log where log.UtcTimestamp < :threshold and log.Configuration.…

Read More
nhibernate fluent-nhibernate hql ora-00933 hql-delete
ORA-00933: SQL command not properly ended

I'm getting this error in Oracle: ORA-00933: SQL command not properly ended for DROP SEQUENCE IF EXISTS ownername.seq_name; …

Read More
sql oracle ora-00933