ORA-00907 Missing right parenthesis Postgresql to Oracle

Question

I am moving from Postgres to Oracle and I am getting the ORA-00907 error for the following statement:

UPDATE investigations SET 

team=(SELECT team FROM assigned WHERE parent_id=investigations.id LIMIT 1);

Please help with my Oracle syntax.

Thanks in advance!

You're updating with a random row... is this intentional? – Ben Jun 30 '13 at 20:57 — Ben, Jun 30 '13 at 20:57

score 2 · Answer 1 · edited May 23 '17 at 12:11

2

As far as I know oracle doesn't have LIMIT clause. Take a look at this topic

edited May 23 '17 at 12:11

Community

answered Jun 30 '13 at 19:54

maks

score 2 · Answer 2 · answered Jun 30 '13 at 19:59

2

you can try using rownum

SELECT team FROM assigned WHERE parent_id=investigations.id and rownum =1

answered Jun 30 '13 at 19:59

Ian Kenney

Good point - but as there was no order by in the original query, it should be pretty similar behaviour in this case – Ian Kenney Jun 30 '13 at 21:01

2 Answers2