INSERT INTO PERIODE (CODE, P1_DEBUT, P1_FIN, P2_DEBUT, P2_FIN)
VALUES ('a', '08:00:00', '09:00:00', '08:30:00', '09:30:00')
INSERT INTO PERIODE (CODE, P1_DEBUT, P1_FIN, P2_DEBUT, P2_FIN)

 

 

 

 

 

 

 

 

 

SELECT *
FROM PERIODE
WHERE (P1_DEBUT > P2_DEBUT AND (P1_DEBUT < P2_FIN OR P1_FIN < P2_FIN)) OR
(P2_DEBUT > P1_DEBUT AND (P2_DEBUT < P1_FIN OR P2_FIN < P1_FIN)) OR
(P1_DEBUT = P2_DEBUT AND (P1_FIN IS NOT NULL AND P2_FIN IS NOT NULL))

/* ============================================================ */
/* Table : TR_PLN_ANNEE_PAN */
/* ============================================================ */

create table TR_PLN_ANNEE_PAN
(
PAN_ID T_D_PLN_ANNEE not null,
PAN_BISEXTILE T_D_PLN_BOOLEEN not null,
constraint PK_TR_PLN_ANNEE_PAN primary key (PAN_ID)
)
;