Query problem with UPDATE

From: Marco Pinzuti <mpinzuti_at_virgilio.it>
Date: 7 Dec 2000 17:22:11 +0100
Message-ID: <20001207162201.ZQZG28429.mta1@[212.48.4.51]>

I've tried to carry out the following query:

UPDATE TAVOLA1
SET CAMPO1 = CAMPO1 + (SELECT CAMPO2 FROM TAVOLA2 WHERE ...); Oracle answers by saying MISSING EXPRESSION

I've solved the issue by writing a PL/SQL program where I put the result of SELECT CAMPO2 FROM TAVOLA2 WHERE .. into a variable X and then by performing:
UPDATE TAVOLA1
SET CAMPO1 = CAMPO1 + X; Does it exists any other way to do so without writing a PL/SQL program?

Thanks in advance

---

Virgilio Mail - Il tuo indirizzo E-mail gratis http://mail.virgilio.it

-- 
Posted from [212.48.4.46] 
via Mailgate.ORG Server - http://www.Mailgate.ORG

Received on Thu Dec 07 2000 - 10:22:11 CST