CREATE TABLE STOK1 (
    STID       INTEGER,
    STASFNO    VARCHAR(10),
    STASID     BIGINT,
    STUID      VARCHAR(10),
    STUAD      VARCHAR(100),
    STBARKOD   VARCHAR(20),
    STISTARIH  DATE,
    STTIP      VARCHAR(10),
    STADET     INTEGER
);

CREATE SEQUENCE GEN_STOK1_ID;

execute procedure STOK_DUZELT;
INSERT INTO Stok1(stuid,stadet)
select stuid,sum(STADET) as toplam from STOK group by stuid

Delete from stok;
ALTER SEQUENCE GEN_STOK_ID RESTART WITH 0;



insert into STOK (STUID,STADET)
select STUID, STADET
from STOK1

Drop table stok1;
DROP SEQUENCE GEN_STOK1_ID;

  merge into stok s
  using urunler u
  on s.stuid=u.uid
  when matched then
  update set
  s.stuad=u.uad,
  s.stbarkod=u.ubarkod;

Update stok set stasfno='ILK STOK', stasid='0', sttip='alış'