Advertisement
Guest User

Untitled

a guest
Feb 9th, 2019
195
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.45 KB | None | 0 0
  1. IF p = 0 THEN
  2.         SELECT id INTO Lp FROM LINIALOTNICZA WHERE LINIA  = :NEW.linialotnicza;
  3.         INSERT INTO lot VALUES(:NEW.nrlotu, Lp, :NEW.kod_lotniska, :NEW.godz_startu, :NEW.godz_ladowania, :NEW.dzientygodnia, :NEW.z_do);
  4.     /* update lotu */
  5.     ELSE
  6.         UPDATE lot SET START_GODZ = :NEW.godz_startu, LADOWANIE_GODZ = :NEW.godz_ladowania, DZIEN_TYG = :NEW.dzientygodnia
  7.         WHERE LOT.NR = :NEW.nrlotu AND LOT.Z_DO = :NEW.z_do;
  8.     END IF;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement