Update row [message #18346] |
Tue, 29 January 2002 01:10 |
PMB
Messages: 2 Registered: January 2002
|
Junior Member |
|
|
I'm using this statemant to update rows:
UPDATE lk_mes p SET VALUE(p) =
(SELECT VALUE(q) FROM lk_mes@medic.algarve q
WHERE q.cod_mes = p.cod_mes)
WHERE p.cod_mes = 199801
but oracle rejects with message of wrong name column. What is wrong?
|
|
|
|
Re: Update row [message #18351 is a reply to message #18346] |
Tue, 29 January 2002 04:35 |
PMB
Messages: 2 Registered: January 2002
|
Junior Member |
|
|
Hello,
@medic.algarve - yes, it is database link.
No, I don't able to execute the stmt because of "VALUE(q)".
Note: This example it is base on documentation Oracle
|
|
|