Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can you help me translate it to dymnamic sql

997232Apr 1 2013 — edited Apr 2 2013
Can you help me translate it to dymnamic sql

merge into spolki t
using (
select aktualne_notowania.aspolka_id,
aktualne_notowania.notowanie * spolki.ilosc_akcji as total
from aktualne_notowania, spolki
where aktualne_notowania.aspolka_id = spolki.spolka_id
) s
on (
t.spolka_id = s.aspolka_id
)
when matched
then
update
set t.wartosc_spolki = s.total
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 30 2013
Added on Apr 1 2013
9 comments
174 views