ORACLE SQL missing right parenthesis bad syntax

Question

I can't seem to figure out where is the syntax mistake. Even though the query is very simple.

Thanks in advance!

UPDATE t_stock
set f_atcid = (select a.id from t_atc a where a.f_code = ' ' where rownum < 2)
where id in (select f_stockid from t_barcode where f_barcode = ' ');

Though is silly mistake I found this to be a common error(having two where clauses). I would keep this question on the site. — Florin Ghita
– Florin Ghita, Commented Mar 18, 2016 at 11:11

Gordon Linoff · Accepted Answer · 2016-03-18 10:50:02Z

2

The problem is two where clauses. Change the second to and:

UPDATE t_stock
    set f_atcid = (select a.id
                   from t_atc a
                   where a.f_code = ' ' and
----------------------------------------^
                         rownum < 2
                  )
where id in (select f_stockid from t_barcode where f_barcode = ' ' );

answered Mar 18, 2016 at 10:50

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

CoffeMug Over a year ago

What a silly mistake. Everything seems to working fine now. Thanks!

Collectives™ on Stack Overflow

ORACLE SQL missing right parenthesis bad syntax

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related