-1
I’m trying to do the update below, only I’m having difficulty. I’m grateful for the help!!
UPDATE pctabpr set pctabpr.ptabela = (SELECT ptabela
FROM pcembalagem
WHERE pcembalagem.codprod = pctabpr.codprod);
What is wrong?
And what is your difficulty?
– gato
I don’t know if my update is correct is giving error when processing
– Douglas Oliveira
What error? Add more details about the problem.
– gato
You need to give more accurate information about which error, the message, the ORA-XXXX error, etc. Anyway, looking at your update, if the subselect brings more than one value will give error, have you checked it? Also, you omitted in your example or your
UPDATE
is out ofWHERE
?– Ricardo Pontual
In order for this UPDATE to work the SELECT in question must return one and only one line, this may be the problem.
– Motta