Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- IF p = 0 THEN
- SELECT id INTO Lp FROM LINIALOTNICZA WHERE LINIA = :NEW.linialotnicza;
- INSERT INTO lot VALUES(:NEW.nrlotu, Lp, :NEW.kod_lotniska, :NEW.godz_startu, :NEW.godz_ladowania, :NEW.dzientygodnia, :NEW.z_do);
- /* update lotu */
- ELSE
- UPDATE lot SET START_GODZ = :NEW.godz_startu, LADOWANIE_GODZ = :NEW.godz_ladowania, DZIEN_TYG = :NEW.dzientygodnia
- WHERE LOT.NR = :NEW.nrlotu AND LOT.Z_DO = :NEW.z_do;
- END IF;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement