ora-00933

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, dbms_random.string('U',5), trunc(dbms_random.value(0000,9999)), prod_id from dba_xy.product prod_name from dba_xy.product; end loop; end; When I run it, oracle gives me the following error messag...

solution for ORA-00933

I'm tring to use join but facing this issue. I've pasted my query select count(*) from table_a inner join table_b on table_a.number = table_b.number left outer join table_c on table_a.id = table_c.id and table_a.number = table_c.number order by number; pls let me know ...

Oracle - Update statement with inner join

I have a query which works fine in MySQL, I'm trying to get it working on oracle but get the following error SQL Error: ORA-00933: SQL command not properly ended 00933. 00000 - "SQL command not properly ended" The query is: UPDATE table1 INNER JOIN table2 ON table1.value = table2.DESC SET table1.value = table2.CODE WHERE table1.UPDAT...

How to handle xpath in SQL query while programming in Java

I am trying to execute the SQL statement from my java application Due website restriction on url I have replaced http=htp for this post. SELECT DISTINCT(DID) FROM (SELECT e_id DID, xml_doc xml, rownum rn from employee_master_indexes)," + " table(XMLSequence(extract(xml,'//cf:SalesReport...

PL/SQL: ORA-00933 command not properly ended

hello Im trying this query: DECLARE v_week NUMBER; BEGIN SELECT WEEK FROM WEEKDESTINATION INTO (v_week) WHERE STARTDATE BETWEEN '02-JAN-2010'AND '09-JAN-2010'; END; but it throws the following error: PL/SQL: ORA-00933: SQL command not properly ended please help ...

ORA-00933: SQL command not properly ended (in simple insert statement)

The following simple statement: INSERT INTO mydb.inventory (itemID) VALUES (:itemID) WHERE playerID = :ID; Generates the following error: ORA-00933: SQL command not properly ended I have tried it without the semi-colon as well as with, but both give me the error. I am certain that the variables are being bound as well. All my Goo...

how to return a dynamic result set in Oracle function

I found a string tokenizer query on the net and packaged it into the below function, which return the dynamic set of tokens. The function compiles successfully but somehow I get the error "ORA-00933: SQL command not properly ended". Can someone please help me debug this? Thank you. CREATE OR REPLACE TYPE KEY_VALUE_TYPE is object (k varc...

Oracle Synonyms issue

My Scenario: Schema name: schema1 Package name: pkg_system procedure name: proc1 Now I am trying to create a synonyms for my proc1 as below CREATE PUBLIC SYNONYM call_proc FOR schema1.pkg_system.proc1; ...but it gave me syntax error. ORA-00933: SQL command not properly ended I changed the code as below: CREATE PUBLIC SYNONYM c...