Facebook
From Funky Tamarin, 8 Years ago, written in Oracle 9.2 PL/SQL.
This paste is a reply to Untitled from Harmless Pheasant - view diff
Embed
Download Paste or View Raw
Hits: 562
  1. CREATE TRIGGER dodaj_zasob
  2. AFTER INSERT ON pozycjedokumentu
  3. FOR EACH ROW
  4. WHEN (NEW.handlowymagazynowy='M' AND NEW.kierunekmagazynu=1)
  5. okres NUMBER(10);
  6. dataprz DATE;
  7. konprz NUMBER(10);
  8.   SELECT id INTO okres FROM OKRESYMAGAZYNOWE
  9.   WHERE CZYZAMKNIETY='N';
  10.   SELECT data INTO dataprz FROM dokumenty
  11.   WHERE id=:NEW.dokument;
  12.   SELECT kontrahent INTO konprz FROM dokumenty
  13.   WHERE id=:NEW.dokument;
  14.   INSERT INTO zasoby
  15.   VALUES (s_id_zas.NEXTVAL, :NEW.ilosc, NULL, :NEW.cena,
  16.   dataprz, :NEW.dokument, :NEW.partiatowaru, :NEW.towary,
  17.   :NEW.magazyn, :NEW.id, okres, konprz);

Replies to Re: Untitled rss

Title Name Language When
Re: Re: Untitled Emerald Peafowl plsql 8 Years ago.
Re: Re: Untitled Sexy Camel plsql 8 Years ago.