Insert into

This preview shows page 22 - 24 out of 32 pages.

TO_DATE('10.10.2018','DD.MM.YYYY'), TO_DATE('10.10.2023','DD.MM.YYYY'), TO_DATE('10.09.2023','DD.MM.YYYY')); INSERT INTO MEMBER (MemberID, Name, NationalID, HomeMailingAddress, EmailAddress, PhoneNumber, MemberPhoto, MembershipStartDate, MmmbershipExpiryDate, RenewalNotificationDate) VALUES (505, 'Bobby Kings', 987654335, 'str 184', '[email protected]', 89786554, null, TO_DATE('06.12.2019','DD.MM.YYYY'), TO_DATE('06.12.2024','DD.MM.YYYY'), TO_DATE('06.11.2024','DD.MM.YYYY')); select * from MEMBER INSERT INTO COUNCILSTAFF (StaffID, Name, NationalID, HomeMailingAddress, EmailAddress, PhoneNumber, EmploymentDate, Designation) VALUES (401, 'David Beckam', 786545, 'str 44', '[email protected]', 3456754, TO_DATE('10-02-2016','DD.MM.YYYY'), 'Senior librarian' ); INSERT INTO COUNCILSTAFF (StaffID, Name, NationalID, HomeMailingAddress, EmailAddress, PhoneNumber, EmploymentDate, Designation) VALUES (402, 'Henry Fox', 865409, 'str 876', '[email protected]', 176544,TO_DATE('10-02- 2016','DD.MM.YYYY'), 'Associate librarian' ); INSERT INTO COUNCILSTAFF (StaffID, Name, NationalID, HomeMailingAddress, EmailAddress, PhoneNumber, EmploymentDate, Designation) VALUES (403, 'Annabel Kitty ', 245677, 'str 276', '[email protected]', 566749, TO_DATE('03- 03-2018','DD.MM.YYYY'), 'Reference librarian' ); INSERT INTO COUNCILSTAFF (StaffID, Name, NationalID, HomeMailingAddress, EmailAddress, PhoneNumber, EmploymentDate, Designation) VALUES (404, 'Sly Pecker',764335, 'str 130', '[email protected]', 349087, TO_DATE('11-11- 2017','DD.MM.YYYY'), 'Librarian assistant' ); Page 22 of 32
INSERT INTO COUNCILSTAFF (StaffID, Name, NationalID, HomeMailingAddress, EmailAddress, PhoneNumber, EmploymentDate, Designation) VALUES (405, 'Eddie Noxx', 983667, 'str 65', '[email protected]', 276345, TO_DATE('02-02- 2020','DD.MM.YYYY'), 'Return staff' ); INSERT INTO COUNCILMEMBER (CMID, StaffID, MembershipStartDate, MmmbershipExpiryDate, RenewalNotificationDate) VALUES (301, 401, TO_DATE('10-02-2016','DD.MM.YYYY'), TO_DATE('10-02- 2021','DD.MM.YYYY'), TO_DATE('10-01-2021','DD.MM.YYYY')); INSERT INTO COUNCILMEMBER (CMID, StaffID, MembershipStartDate, MmmbershipExpiryDate, RenewalNotificationDate) VALUES (302, 402, TO_DATE('10-02-2016','DD.MM.YYYY'), TO_DATE('10-02- 2021','DD.MM.YYYY'), TO_DATE('10-01-2021','DD.MM.YYYY')); INSERT INTO COUNCILMEMBER (CMID, StaffID, MembershipStartDate, MmmbershipExpiryDate, RenewalNotificationDate) VALUES (303, 403, TO_DATE('03-03-2018','DD.MM.YYYY'), TO_DATE('03-03- 2023','DD.MM.YYYY'), TO_DATE('03-02-2023','DD.MM.YYYY')); INSERT INTO COUNCILMEMBER (CMID, StaffID, MembershipStartDate, MmmbershipExpiryDate, RenewalNotificationDate) VALUES (304, 404, TO_DATE('11-11-2017','DD.MM.YYYY'), TO_DATE('11-11- 2022','DD.MM.YYYY'),TO_DATE('11-10-2022','DD.MM.YYYY')); INSERT INTO COUNCILMEMBER (CMID, StaffID, MembershipStartDate, MmmbershipExpiryDate, RenewalNotificationDate) VALUES (305, 405, TO_DATE('02-02-2020','DD.MM.YYYY'), TO_DATE('02-02- 2025','DD.MM.YYYY') , TO_DATE('02-01-2025','DD.MM.YYYY')); INSERT INTO COUNCILMEMBERBORROWING (CMBID, ISBN2, CMID, DateBorrowed, ReturnDate, NoticeDate, Totalbooks) VALUES (101, 1000, 301, TO_DATE('01-10-2020','DD.MM.YYYY') , TO_DATE('01-12- 2020','DD.MM.YYYY'), TO_DATE('15-12-2020','DD.MM.YYYY'), 5); INSERT INTO COUNCILMEMBERBORROWING (CMBID, ISBN2, CMID, DateBorrowed, ReturnDate, NoticeDate, Totalbooks) VALUES (102, 2000, 302, TO_DATE('14-10-2020','DD.MM.YYYY'), TO_DATE('14-12- 2020','DD.MM.YYYY'), TO_DATE('28-12-2020','DD.MM.YYYY'), 7); INSERT INTO COUNCILMEMBERBORROWING (CMBID, ISBN2, CMID, DateBorrowed, ReturnDate, NoticeDate, Totalbooks) VALUES (103, 4000, 303, TO_DATE('10-07-2020','DD.MM.YYYY'), TO_DATE('12-07- 2020','DD.MM.YYYY'), TO_DATE('12-11-2020','DD.MM.YYYY'), 2); INSERT INTO COUNCILMEMBERBORROWING (CMBID, ISBN2, CMID,

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture