-
Notifications
You must be signed in to change notification settings - Fork 0
/
fake_data_borrowing.sql
18 lines (16 loc) · 1.76 KB
/
fake_data_borrowing.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
INSERT INTO Borrowing VALUES(borid_counter.nextVal, 4001, 'ROWLING HPPhilosopher', 1, '2017-10-10', '2017-10-10');
INSERT INTO Borrowing VALUES(borid_counter.nextVal, 4001, 'ROWLING HPPhilosopher', 3, '2017-8-10', NULL);
INSERT INTO Borrowing VALUES(borid_counter.nextVal, 4001, 'ROWLING HPPhilosopher', 5, '2017-7-10', '2017-7-12');
INSERT INTO Borrowing VALUES(borid_counter.nextVal, 4001, 'ROWLING HPPhilosopher', 6, '2017-10-10', NULL);
INSERT INTO Borrowing VALUES(borid_counter.nextVal, 4002, 'ROWLING HPChamber', 1, '2017-10-10', '2017-10-10');
INSERT INTO Borrowing VALUES(borid_counter.nextVal, 4002, 'ROWLING HPChamber', 4, '2013-3-3', NULL);
INSERT INTO Borrowing VALUES(borid_counter.nextVal, 4002, 'ROWLING HPChamber', 5, '2017-5-10', '2017-5-12');
INSERT INTO Borrowing VALUES(borid_counter.nextVal, 4002, 'ROWLING HPChamber', 6, '2017-5-10', NULL);
INSERT INTO Borrowing VALUES(borid_counter.nextVal, 4003, 'ROWLING HPPrisoner', 1, '2017-10-10', '2017-10-10');
INSERT INTO Borrowing VALUES(borid_counter.nextVal, 4004, 'ROWLING HPGoblet', 1, '2017-12-10', '2017-12-13');
INSERT INTO Borrowing VALUES(borid_counter.nextVal, 4005, 'ROWLING HPOrder', 1, '2015-10-10', '2017-10-10');
INSERT INTO Borrowing VALUES(borid_counter.nextVal, 4001, 'ROWLING HPHalf', 1, TO_DATE('2015-12-05','YYYY-MM-DD'), NULL);
INSERT INTO Borrowing VALUES(borid_counter.nextVal, 4002, 'ROWLING HPDeathly', 1, TO_DATE('2014-01-25','YYYY-MM-DD'), NULL);
INSERT INTO Borrowing VALUES(borid_counter.nextVal, 4003, 'STEWART Calculus', 3, TO_DATE('2012-08-10','YYYY-MM-DD'), NULL);
INSERT INTO Borrowing VALUES(borid_counter.nextVal, 4002, 'DAWKINS Selfish', 1, TO_DATE('2011-10-10','YYYY-MM-DD'), NULL);
INSERT INTO Borrowing VALUES(borid_counter.nextVal, 4005, 'BIBLE', 3, TO_DATE('2012-04-25','YYYY-MM-DD'), NULL);