INSERT INTO borrower(borrower_id,borrower_name,birth_date,address,phone,email)
SELECT 'BR'||LPAD(borrower_borrower_id_seq.NEXTVAL,3,0), 'Jeffry Steward Witarsah',TO_DATE('24 July 1993','DD Month YYYY'),'Gading Serpong','08170110049','jeffrysw@yahoo.com'
FROM dual;
INSERT INTO borrower(borrower_id,borrower_name,birth_date,address,phone,email)
SELECT 'BR'||LPAD(borrower_borrower_id_seq.NEXTVAL,3,0),'Stevian Hebie Valentino',TO_DATE('22 September 1992','DD Month YYYY'),'Tangerang','08150310074','stevianhv@gmail.com'
FROM dual;
INSERT INTO borrower(borrower_id,borrower_name,birth_date,address,phone,email)
SELECT 'BR'||LPAD(borrower_borrower_id_seq.NEXTVAL,3,0),'Vincencius Kevin',TO_DATE('4 September 1992','DD Month YYYY'),'Bengkulu','08780110064','vinceciusk@yahoo.com'
FROM dual;
INSERT INTO borrower(borrower_id,borrower_name,birth_date,address,phone,email)
SELECT 'BR'||LPAD(borrower_borrower_id_seq.NEXTVAL,3,0),'Billy Permana Halim',TO_DATE('21 October 1992','DD Month YYYY'),'Bumi Serpong Damai','08190110061','billyph@gmail.com'
FROM dual;
INSERT INTO borrower(borrower_id,borrower_name,birth_date,address,phone,email)
SELECT 'BR'||LPAD(borrower_borrower_id_seq.NEXTVAL,3,0),'Idul Futra',TO_DATE('6 April 1992','DD Month YYYY'),'Riau','08160110001','idulf@hotmail.com'
FROM dual;

INSERT INTO librarian (librarian_id,librarian_name,birth_date,address,phone,email)
SELECT 'LB'||LPAD(librarian_librarian_id_seq.NEXTVAL,3,0),'Steven Young',TO_DATE('26 December 1991','DD Month YYYY'),'Bengkulu','08780110062','steveny@gmail.com'
FROM dual;
INSERT INTO librarian (librarian_id,librarian_name,birth_date,address,phone,email)
SELECT 'LB'||LPAD(librarian_librarian_id_seq.NEXTVAL,3,0),'Lisa Amanda',TO_DATE('11 April 1992','DD Month YYYY'),'Jakarta','08170310021','lisaa@yahoo.com'
FROM dual;
INSERT INTO librarian (librarian_id,librarian_name,birth_date,address,phone,email)
SELECT 'LB'||LPAD(librarian_librarian_id_seq.NEXTVAL,3,0),'Marsel Widjaja',TO_DATE('20 August 1992','DD Month YYYY'),'Tangerang','08780110090','marselw@gmail.com'
FROM dual;
INSERT INTO librarian (librarian_id,librarian_name,birth_date,address,phone,email)
SELECT 'LB'||LPAD(librarian_librarian_id_seq.NEXTVAL,3,0),'Giam Cen Jiang',TO_DATE('1 December 1992','DD Month YYYY'),'Pekalongan','08150110122','giamcj@gmail.com'
FROM dual;
INSERT INTO librarian (librarian_id,librarian_name,birth_date,address,phone,email)
SELECT 'LB'||LPAD(librarian_librarian_id_seq.NEXTVAL,3,0),'Joko Haryanto',TO_DATE('7 January 1992','DD Month YYYY'),'Serang','08160110137','jokoh@yahoo.com'
FROM dual;

INSERT INTO transaction(transaction_id,transaction_date,return_date,borrower_id,book_id,librarian_id)
SELECT 'TR'||LPAD(transaction_transaction_id_seq.NEXTVAL,3,0),TO_DATE('7 November 2012','DD Month YYYY'),TO_DATE('14 November 2012','DD Month YYYY'),'BR003','BK005','LB001'
FROM dual;
INSERT INTO transaction(transaction_id,transaction_date,return_date,borrower_id,book_id,librarian_id)
SELECT 'TR'||LPAD(transaction_transaction_id_seq.NEXTVAL,3,0),TO_DATE('10 September 2012','DD Month YYYY'),TO_DATE('12 September 2012','DD Month YYYY'),'BR002','BK002','LB004'
FROM dual;
INSERT INTO transaction(transaction_id,transaction_date,return_date,borrower_id,book_id,librarian_id)
SELECT 'TR'||LPAD(transaction_transaction_id_seq.NEXTVAL,3,0),TO_DATE('13 September 2012','DD Month YYYY'),TO_DATE('20 September 2012','DD Month YYYY'),'BR005','BK003','LB003'
FROM dual;
INSERT INTO transaction(transaction_id,transaction_date,return_date,borrower_id,book_id,librarian_id)
SELECT 'TR'||LPAD(transaction_transaction_id_seq.NEXTVAL,3,0),TO_DATE('2 October 2012','DD Month YYYY'),TO_DATE('9 October 2012','DD Month YYYY'),'BR001','BK003','LB002'
FROM dual;
INSERT INTO transaction(transaction_id,transaction_date,return_date,borrower_id,book_id,librarian_id)
SELECT 'TR'||LPAD(transaction_transaction_id_seq.NEXTVAL,3,0),TO_DATE('23 October 2012','DD Month YYYY'),TO_DATE('30 October 2012','DD Month YYYY'),'BR004','BK006','LB002'
FROM dual;
INSERT INTO transaction(transaction_id,transaction_date,return_date,borrower_id,book_id,librarian_id)
SELECT 'TR'||LPAD(transaction_transaction_id_seq.NEXTVAL,3,0),TO_DATE('30 August 2012','DD Month YYYY'),TO_DATE('6 September 2012','DD Month YYYY'),'BR001','BK004','LB001'
FROM dual;
INSERT INTO transaction(transaction_id,transaction_date,return_date,borrower_id,book_id,librarian_id)
SELECT 'TR'||LPAD(transaction_transaction_id_seq.NEXTVAL,3,0),TO_DATE('27 July 2012','DD Month YYYY'),TO_DATE('3 August 2012','DD Month YYYY'),'BR003','BK006','LB003'
FROM dual;
INSERT INTO transaction(transaction_id,transaction_date,return_date,borrower_id,book_id,librarian_id)
SELECT 'TR'||LPAD(transaction_transaction_id_seq.NEXTVAL,3,0),TO_DATE('8 August 2012','DD Month YYYY'),TO_DATE('15 August 2012','DD Month YYYY'),'BR005','BK002','LB004'
FROM dual;