Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- BEGIN
- IF :P9_CREATE_IDPOK = (SELECT ID_POKOJU
- FROM REZERWACJE
- WHERE
- (:P9_CREATE_DATAOD>POCZ AND :P9_CREATE_DATADO<KONIEC)
- OR (:P9_CREATE_DATAOD<POCZ AND :P9_CREATE_DATADO<KONIEC AND :P9_CREATE_DATAOD>POCZ)
- OR (:P9_CREATE_DATAOD<KONIEC AND :P9_CREATE_DATADO>KONIEC))
- THEN
- INSERT INTO REZERWACJE (ID_POKOJU, ID_KLIENTA, POCZ, KONIEC, OSOB) VALUES (:P9_CREATE_IDPOK, :P9_CREATE_IDKLIENT, :P9_CREATE_DATAOD, :P9_CREATE_DATADO,:P9_CREATE_OSOB);
- END IF;
- END;
Add Comment
Please, Sign In to add comment