Guest User

Untitled

a guest
May 21st, 2018
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.19 KB | None | 0 0
  1. CREATE OR REPLACE TRIGGER Correct_TimeTible
  2. INSTEAD of Insert ON Timetable1
  3. BEGIN
  4. if to_char(:new.DATE_BEGIN, 'hh24:mi') >= to_char('9:00', 'hh24:mi') and
  5. to_char(:new.DATE_BEGIN, 'hh24:mi') <= to_char('16.30', 'hh24:mi')
  6. then Insert into Timetable values (:new.ID_TIMETABLE,:new.ID_SUBJECT,:new.ID_TEACHER,:new.ID_TYPE,:new.DATE_BEGIN);
  7. ELSE dbms_output.put_line('Incorrected time');
  8. end if;
  9. END;
  10.  
  11. CREATE TABLE "TIMETABLE"
  12. ( "ID_TIMETABLE" NUMBER,
  13. "ID_SUBJECT" NUMBER,
  14. "ID_TEACHER" NUMBER,
  15. "ID_TYPE" NUMBER,
  16. "DATE_BEGIN" DATE,
  17. CONSTRAINT "TIMETABLE_PK" PRIMARY KEY ("ID_TIMETABLE") ENABLE,
  18. CONSTRAINT "SUB_TIME_FK" FOREIGN KEY ("ID_SUBJECT")
  19. REFERENCES "SUBJECT" ("ID_SUBJECT") ENABLE,
  20. CONSTRAINT "TEACH_TIME_FK" FOREIGN KEY ("ID_TEACHER")
  21. REFERENCES "TEACHER" ("ID_TEACHER") ENABLE,
  22. CONSTRAINT "TYPE_TIME_FK" FOREIGN KEY ("ID_TYPE")
  23. REFERENCES "TYPE_SUBJECT" ("ID_TYPE") ENABLE
  24. )
  25. /
  26.  
  27. insert into Timetable1 (ID_TIMETABLE,ID_SUBJECT,ID_TEACHER,ID_TYPE,DATE_BEGIN)
  28. values (SEQ_TIMETABLE.nextval,'1','3','1',to_date('20.05.2018 15:00','dd.mm.yyyy hh24:mi')
  29. );
  30.  
  31. if to_char(:new.date_begin, 'hh24mi') >= '0900' and
  32. to_char(:new.date_begin, 'hh24mi') <= '1630'
  33. then
  34. ...
Add Comment
Please, Sign In to add comment