Top "Ora-00933" questions

Update statement with inner join on Oracle

I have a query which works fine in MySQL, but when I run it on Oracle I get the following …

sql oracle inner-join ora-00933

how to modify an existing check constraint?

Is there any way to modify an existing check constraint on a table other than dropping and re-creating it? create …

oracle ora-00933

SQL Inner join on select statements

I am trying to make an inner join on a select statement like this: select * from (select* from bars where …

sql oracle ora-00933

PLS-00103: Encountered the symbol "end-of-file" in simple update block

The following Oracle statement: DECLARE ID NUMBER; BEGIN UPDATE myusername.terrainMap SET playerID = :playerID,tileLayout = :tileLayout WHERE ID = :ID END; …

sql oracle plsql ora-00933 ora-06550

ora-00933:SQL command not properly ended

I have the following code: begin for i in 1..2 loop insert into dba_xy.despatch select desp_id_seq.nextval, …

sql oracle plsql ora-00933 ora-00001

Oracle : receiving ORA-06550 and PLS-00905

i have a holiday table which contains the data are HOLIDAYDA DESCRIPTION --------- -------------------- 19-JAN-11 to 17-JAN-11 to 10-JAN-11 new …

sql oracle plsql ora-00933 ora-06550

Modify unique constraint in Oracle

I need to update an existing constraint in Oracle database to add a new column there. ALTER TABLE MY_PARTNER_…

sql oracle constraints ora-00933

Oracle ORA-00933: SQL command not properly ended?

I keep getting this error. How do I solve this problem? Error: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly …

sql eclipse oracle sql-update ora-00933

Update with self-join

I want to update a table to indicate that some rows are parents of others, so I added a "parentid" …

sql oracle sql-update ora-00933

Update SQL with two tables in Oracle

I have a sql like this UPDATE A SET A.TEMSILCI_KOD = 4 FROM S_MUSTERI A, S_TEKLIF B WHERE …

sql oracle sql-update ora-00933