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!

Sql Update join problem

ömer faruk akyüzlüFeb 18 2020 — edited Feb 19 2020

Hello,

update teklif_urun a, (select urun_kodu,kondisyon,count(*) as "Miktar" from rma_internet_Seri group by rmano,urun_kodu,kondisyon where RMANO=:P111_RMANO) b set a.MIKTAR =b."Miktar"

where a.RMANO=:P111_RMANO and a.urun_kodu=b.urun_kodu and a.kondisyon=b.kondisyon

ORA-00971: eksik SET anahtar sözcüğü ORA-06512: konum "SYS.WWV_DBMS_SQL_APEX_190200", satır 592 ORA-06512: konum "SYS.DBMS_SYS_SQL", satır 1658 ORA-06512: konum "SYS.WWV_DBMS_SQL_APEX_190200", satır 578 ORA-06512: konum "APEX_190200.WWV_FLOW_DYNAMIC_EXEC", satır 2057

Added on Feb 18 2020

#sql, #update

4 comments

275 views