[sql] P2
Viewer
- /** DROP TABLE*/
- DROP TABLE CUSTOMER cascade constraints;
- DROP TABLE BRANCH cascade constraints;
- DROP TABLE TRANSACTION cascade constraints;
- DROP TABLE PYSICAL_ITEM cascade constraints;
- DROP TABLE GATALOG_ITEM cascade constraints;
- DROP TABLE BOOK cascade constraints;
- DROP TABLE DVD cascade constraints;
- DROP TABLE LIBRARY cascade constraints;
- DROP TABLE LIBRARY_CARD cascade constraints;
- /** CREAT TABLE*/
- CREATE TABLE CUSTOMER (Customer_ID_number PRIMARY KEY, Customer_Firstname VARCHAR2(20), Customer_Lastname VARCHAR2(20), Customer_Street VARCHAR2(20), Customer_City VARCHAR2(20), Customer_State VARCHAR2(20), Customer_Zip VARCHAR2(10));
- CREATE TABLE BRANCH (Branch_ ID_number PRIMARY KEY, Branch_Name VARCHAR2(20), Branch_Phone VARCHAR2 (20), Branch_Address VARCHAR2(20), LIBRARY_ID NUMBER);
- CREATE TABLE TRANSACTION (Transaction_ ID_number PRIMARY KEY, Date_checkout DATE, Date_Due DATE, Date_Returned DATE, Library_Card_ID NUMBER, Physical_Item_ID NUMBER);
- CREATE TABLE PHYSICAL_ITEM (Physical_Item_ID_number PRIMARY KEY, Branch_ID NUMBER, Catalog_Item_ID NUMBER, Copy_Number NUMBER, Date_Purchased DATE);
- CREATE TABLE CATALOG_ITEM (Catalog_Item_ID_number PRIMARY KEY, Title VARCHAR2 (20), Description VARCHAR2(20), Publisher VARCHAR2 (20), Release_Date DATE, TYPE VARCHAR2(20));
- CREATE TABLE BOOK (Catalog_Item_ ID_number, ISBN VARCHAR2(13), Pages NUMBER);
- CREATE TABLE DVD (Catalog_Item_ ID_number, LENGTH VARCHAR2(20));
- CREATE TABLE LIBRARY (Library_ ID_number PRIMARY KEY, Library_Name VARCHAR2 (20), Library_Phone VARCHAR2(20), Library_Address VARCHAR2(20));
- CREATE TABLE LIBRARY_CARD (Library_Card_ ID_number PRIMARY KEY, Library_ID NUMBER, Customer_ID NUMBER, Card_Number VARCHAR2(20), PIN VARCHAR2(8), Date_Expire DATE);
- /** CUSTOMER */
- INSERT INTO CUSTOMER
- (CUSTOMER_ID, CUSTOMER_FIRSTNAME, CUSTOMER_LASTNAME, CUSTOMER_STREET, CUSTOMER_CITY, CUSTOMER_STATE, CUSTOMER_ZIP)
- VALUES (1, 'Christian', 'Walker', '96 Clark Drive', 'Hicksvile', 'NY', '11801');
- INSERT INTO CUSTOMER
- (CUSTOMER_ID, CUSTOMER_FIRSTNAME, CUSTOMER_LASTNAME, CUSTOMER_STREET, CUSTOMER_CITY, CUSTOMER_STATE, CUSTOMER_ZIP)
- VALUES (4, 'Emile', 'Cross', '387 Circle Ave', 'Vincentown', 'NJ', '08088');
- INSERT INTO CUSTOMER
- (CUSTOMER_ID, CUSTOMER_FIRSTNAME, CUSTOMER_LASTNAME, CUSTOMER_STREET, CUSTOMER_CITY, CUSTOMER_STATE, CUSTOMER_ZIP)
- VALUES (2, 'Deena', 'Pilgrim', '838 Orange Street', 'Frederick', 'MD', '21701');
- INSERT INTO CUSTOMER
- (CUSTOMER_ID, CUSTOMER_FIRSTNAME, CUSTOMER_LASTNAME, CUSTOMER_STREET, CUSTOMER_CITY, CUSTOMER_STATE, CUSTOMER_ZIP)
- VALUES (3, 'Calista', 'Secor', '9330 El Dorado Lane', 'Temple Hills', 'MD', '20748');
- INSERT INTO CUSTOMER
- (CUSTOMER_ID, CUSTOMER_FIRSTNAME, CUSTOMER_LASTNAME, CUSTOMER_STREET, CUSTOMER_CITY, CUSTOMER_STATE, CUSTOMER_ZIP)
- VALUES (5, 'Johnny', 'Royalle', '9948 Campfire Drive', 'East Elmhurst', 'NY', '11369');
- INSERT INTO CUSTOMER
- (CUSTOMER_ID, CUSTOMER_FIRSTNAME, CUSTOMER_LASTNAME, CUSTOMER_STREET, CUSTOMER_CITY, CUSTOMER_STATE, CUSTOMER_ZIP)
- VALUES (6, 'Harley', 'Cohen', '96 Vine Street', 'Bowie', 'MD', '20715');
- /**BRANCH */
- INSERT INTO BRANCH
- (BRANCH_ID, BRANCH_NAME, BRANCH_PHONE, BRANCH_ADDRESS, LIBRARY_ID)
- VALUES (101, '125th Street Library', '212-555-2345', '224 E 125th St, New York, NY', 1);
- INSERT INTO BRANCH
- (BRANCH_ID, BRANCH_NAME, BRANCH_PHONE, BRANCH_ADDRESS, LIBRARY_ID)
- VALUES (102, 'Grand Central Library', '212-555-3456', '135 E 46th St, New York, NY', 1);
- INSERT INTO BRANCH
- (BRANCH_ID, BRANCH_NAME, BRANCH_PHONE, BRANCH_ADDRESS, LIBRARY_ID)
- VALUES (201, 'Essex Branch', '443-555-4567', '1100 Eastern Blvd, Essex, MD', 2);
- INSERT INTO BRANCH
- (BRANCH_ID, BRANCH_NAME, BRANCH_PHONE, BRANCH_ADDRESS, LIBRARY_ID)
- VALUES (202, 'Woodlawn Branch', '443-555-5678', '1811 Woodlawn Dr, Woodlawn, MD', 2);
- INSERT INTO BRANCH
- (BRANCH_ID, BRANCH_NAME, BRANCH_PHONE, BRANCH_ADDRESS, LIBRARY_ID)
- VALUES (301, 'UMUC Library Largo', '240-684-2020', '1616 McCormick Dr, Largo, MD', 3);
- INSERT INTO BRANCH
- (BRANCH_ID, BRANCH_NAME, BRANCH_PHONE, BRANCH_ADDRESS, LIBRARY_ID)
- VALUES (302, 'McKeldin Library', '301-405-9046', 'UMD, College Park, MD', 3);
- /**TRANSACTION */
- INSERT INTO TRANSACTION
- (TRANSACTION_ID, DATE_CHECKOUT, DATE_DUE, DATE_RETURNED, LIBRARY_CARD_ID,
- PHYSICAL_ITEM_ID)
- VALUES (2, TO_DATE('02/28/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('03/28/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('04/01/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 2);
- INSERT INTO TRANSACTION
- (TRANSACTION_ID, DATE_CHECKOUT, DATE_DUE, DATE_RETURNED, LIBRARY_CARD_ID,
- PHYSICAL_ITEM_ID)
- VALUES (3, TO_DATE('04/01/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('05/01/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('04/03/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 13);
- INSERT INTO TRANSACTION
- (TRANSACTION_ID, DATE_CHECKOUT, DATE_DUE, DATE_RETURNED, LIBRARY_CARD_ID,
- PHYSICAL_ITEM_ID)
- VALUES (1, TO_DATE('02/02/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('03/02/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('02/28/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 1);
- INSERT INTO TRANSACTION
- (TRANSACTION_ID, DATE_CHECKOUT, DATE_DUE, DATE_RETURNED, LIBRARY_CARD_ID,
- PHYSICAL_ITEM_ID)
- VALUES (4, TO_DATE('04/03/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('05/03/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('04/30/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1, 20);
- INSERT INTO TRANSACTION
- (TRANSACTION_ID, DATE_CHECKOUT, DATE_DUE, DATE_RETURNED, LIBRARY_CARD_ID,
- PHYSICAL_ITEM_ID)
- VALUES (5, TO_DATE('03/03/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('04/03/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('03/28/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 1);
- INSERT INTO TRANSACTION
- (TRANSACTION_ID, DATE_CHECKOUT, DATE_DUE, DATE_RETURNED, LIBRARY_CARD_ID,
- PHYSICAL_ITEM_ID)
- VALUES (6, TO_DATE('12/12/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('01/12/2018 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 2, 3);
- INSERT INTO TRANSACTION
- (TRANSACTION_ID, DATE_CHECKOUT, DATE_DUE, DATE_RETURNED, LIBRARY_CARD_ID,
- PHYSICAL_ITEM_ID)
- VALUES (7, TO_DATE('12/12/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('01/12/2018 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 2, 4);
- INSERT INTO TRANSACTION
- (TRANSACTION_ID, DATE_CHECKOUT, DATE_DUE, DATE_RETURNED, LIBRARY_CARD_ID,
- PHYSICAL_ITEM_ID)
- VALUES (11, TO_DATE ('09/21/2017 00:00:00', 'MM/DD/YYYY HH24:MI: SS'), TO_DATE ('10/21/2017 00:00:00', 'MM/DD/YYYY HH24:MI: SS'), NULL, 3, 42);
- INSERT INTO TRANSACTION
- (TRANSACTION_ID, DATE_CHECKOUT, DATE_DUE, DATE_RETURNED, LIBRARY_CARD_ID,
- PHYSICAL_ITEM_ID)
- VALUES (12, TO_DATE('05/12/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('06/12/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('05/31/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 42);
- INSERT INTO TRANSACTION
- (TRANSACTION_ID, DATE_CHECKOUT, DATE_DUE, DATE_RETURNED, LIBRARY_CARD_ID,
- PHYSICAL_ITEM_ID)
- VALUES (8, TO_DATE('07/14/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('08/14/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('08/20/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 21);
- INSERT INTO TRANSACTION
- (TRANSACTION_ID, DATE_CHECKOUT, DATE_DUE, DATE_RETURNED, LIBRARY_CARD_ID,
- PHYSICAL_ITEM_ID)
- VALUES (9, TO_DATE('08/20/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('09/20/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('09/19/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 22);
- INSERT INTO TRANSACTION
- (TRANSACTION_ID, DATE_CHECKOUT, DATE_DUE, DATE_RETURNED, LIBRARY_CARD_ID,
- PHYSICAL_ITEM_ID)
- VALUES (10, TO_DATE('09/19/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('10/19/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('09/21/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3, 29);
- INSERT INTO TRANSACTION
- (TRANSACTION_ID, DATE_CHECKOUT, DATE_DUE, DATE_RETURNED, LIBRARY_CARD_ID,
- PHYSICAL_ITEM_ID)
- VALUES (13, TO_DATE('05/12/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('06/12/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('05/31/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 41);
- INSERT INTO TRANSACTION
- (TRANSACTION_ID, DATE_CHECKOUT, DATE_DUE, DATE_RETURNED, LIBRARY_CARD_ID,
- PHYSICAL_ITEM_ID)
- VALUES (19, TO_DATE('07/21/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('08/21/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('07/22/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 7, 54);
- INSERT INTO TRANSACTION
- (TRANSACTION_ID, DATE_CHECKOUT, DATE_DUE, DATE_RETURNED, LIBRARY_CARD_ID,
- PHYSICAL_ITEM_ID)
- VALUES (14, TO_DATE('05/12/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('06/12/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('05/31/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4, 40);
- INSERT INTO TRANSACTION
- (TRANSACTION_ID, DATE_CHECKOUT, DATE_DUE, DATE_RETURNED, LIBRARY_CARD_ID,
- PHYSICAL_ITEM_ID)
- VALUES (15, TO_DATE('11/11/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('12/11/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('12/09/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 6, 51);
- INSERT INTO TRANSACTION
- (TRANSACTION_ID, DATE_CHECKOUT, DATE_DUE, DATE_RETURNED, LIBRARY_CARD_ID,
- PHYSICAL_ITEM_ID)
- VALUES (16, TO_DATE('12/09/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('01/09/2018 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 6, 45);
- INSERT INTO TRANSACTION
- (TRANSACTION_ID, DATE_CHECKOUT, DATE_DUE, DATE_RETURNED, LIBRARY_CARD_ID,
- PHYSICAL_ITEM_ID)
- VALUES (17, TO_DATE('12/12/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('01/12/2018 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('12/20/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 6, 51);
- INSERT INTO TRANSACTION
- (TRANSACTION_ID, DATE_CHECKOUT, DATE_DUE, DATE_RETURNED, LIBRARY_CARD_ID,
- PHYSICAL_ITEM_ID)
- VALUES (20, TO_DATE('10/12/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('11/12/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('10/22/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 3);
- INSERT INTO TRANSACTION
- (TRANSACTION_ID, DATE_CHECKOUT, DATE_DUE, DATE_RETURNED, LIBRARY_CARD_ID,
- PHYSICAL_ITEM_ID)
- VALUES (21, TO_DATE('10/10/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('11/10/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('10/22/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2, 4);
- COMMIT;
- /** PYYSCIAL_ITEM*/
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (102, 8, 20, 3, TO_DATE('02/23/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (101, 1, 1, 1, TO_DATE('02/01/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (101, 1, 2, 2, TO_DATE('03/15/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (101, 4, 6, 2, TO_DATE('02/01/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (101, 4, 5, 1, TO_DATE('02/01/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (101, 4, 7, 3, TO_DATE('10/09/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (101, 7, 8, 1, TO_DATE('02/01/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (101, 7, 9, 2, TO_DATE('04/15/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (101, 7, 10, 3, TO_DATE('12/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (101, 7, 11, 4, TO_DATE('12/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (101, 7, 12, 5, TO_DATE('12/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (102, 3, 14, 2, TO_DATE('07/08/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (102, 3, 15, 3, TO_DATE('07/08/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (102, 5, 16, 1, TO_DATE('03/01/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (102, 6, 17, 1, TO_DATE('12/12/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (102, 8, 18, 1, TO_DATE('10/01/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (102, 8, 19, 2, TO_DATE('10/01/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (201, 1, 21, 1, TO_DATE('06/14/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (102, 3, 13, 1, TO_DATE('07/08/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (101, 2, 3, 1, TO_DATE('03/04/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (101, 2, 4, 2, TO_DATE('03/04/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (201, 1, 22, 2, TO_DATE('06/14/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (201, 2, 23, 1, TO_DATE('06/14/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (201, 2, 24, 2, TO_DATE('06/14/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (201, 3, 25, 1, TO_DATE('06/14/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (201, 4, 26, 1, TO_DATE('06/14/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (201, 5, 27, 1, TO_DATE('06/14/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (201, 6, 28, 1, TO_DATE('06/14/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES
- (201, 7, 29, 1, TO_DATE('06/14/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (201, 7, 30, 2, TO_DATE('06/14/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (201, 7, 31, 3, TO_DATE('06/14/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (201, 8, 32, 1, TO_DATE('06/14/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (202, 1, 33, 1, TO_DATE('03/03/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (202, 2, 34, 1, TO_DATE('08/19/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (202, 3, 35, 1, TO_DATE('08/19/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (202, 3, 36, 2, TO_DATE('09/21/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (202, 3, 37, 3, TO_DATE('09/21/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (202, 4, 38, 1, TO_DATE('11/25/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (202, 4, 39, 2, TO_DATE('02/23/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (202, 5, 40, 1, TO_DATE('12/12/2016 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES
- (202, 6, 41, 1, TO_DATE('05/15/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (202, 8, 42, 1, TO_DATE('09/15/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (301, 1, 43, 1, TO_DATE('09/11/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (301, 2, 44, 1, TO_DATE('01/12/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (301, 3, 45, 1, TO_DATE('09/09/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (301, 3, 46, 2, TO_DATE('09/09/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (301, 3, 47, 3, TO_DATE('07/14/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (301, 4, 49, 1, TO_DATE('01/20/2013 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (301, 4, 50, 2, TO_DATE('02/05/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (301, 5, 51, 1, TO_DATE('07/11/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (301, 7, 53, 1, TO_DATE('04/09/2016 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (301, 8, 54, 1, TO_DATE('12/17/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (302, 1, 55, 1, TO_DATE('03/08/2016 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (302, 2, 56, 1, TO_DATE('07/12/2016 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (302, 4, 57, 1, TO_DATE('12/01/2016 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (301, 6, 52, 1, TO_DATE('07/11/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (302, 7, 58, 1, TO_DATE('01/14/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (102, 7, 59, 1, TO_DATE('01/14/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'))
- INSERT INTO PHYSICAL_ITEM
- (BRANCH_ID, CATALOG_ITEM_ID, PHYSICAL_ITEM_ID, COPY_NUMBER, DATE_PURCHASED)
- VALUES (301, 3, 48, 4, TO_DATE('10/19/2016 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- /**CATALOG_ITEM */
- INSERT INTO CATALOG_ITEM
- (CATALOG_ITEM_ID, TITLE, DESCRIPTION, PUBLISHER, RELEASE_DATE, TYPE)
- VALUES (1, 'Way of Kings', 'Fantasy', 'Tor Books', TO_DATE('08/31/2010 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOOK');
- INSERT INTO CATALOG_ITEM
- (CATALOG_ITEM_ID, TITLE, DESCRIPTION, PUBLISHER, RELEASE_DATE, TYPE)
- VALUES (3, 'Inception', 'Science Fiction/Thriller', 'Warner Bros', TO_DATE('07/08/2010 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'DVD');
- INSERT INTO CATALOG_ITEM
- (CATALOG_ITEM_ID, TITLE, DESCRIPTION, PUBLISHER, RELEASE_DATE,
- TYPE)
- VALUES (8, 'The Social Network', 'Drama', 'Columbia Pictures', TO_DATE('10/01/2010 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'DVD');
- INSERT INTO CATALOG_ITEM
- (CATALOG_ITEM_ID, TITLE, DESCRIPTION, PUBLISHER, RELEASE_DATE, TYPE)
- VALUES (2, 'Words of Radiance', 'Fantasy', 'Tor Books', TO_DATE('03/04/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOOK');
- INSERT INTO CATALOG_ITEM
- (CATALOG_ITEM_ID, TITLE, DESCRIPTION, PUBLISHER, RELEASE_DATE, TYPE)
- VALUES (7, 'The Name of the Wind', 'Fantasy', 'DAW Books', TO_DATE('03/27/2007 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOOK');
- INSERT INTO CATALOG_ITEM
- (CATALOG_ITEM_ID, TITLE, DESCRIPTION, PUBLISHER, RELEASE_DATE, TYPE)
- VALUES (6, 'Moonrise Kingdom', 'Drama Comedy', 'Focus Features', TO_DATE('05/25/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'DVD');
- INSERT INTO CATALOG_ITEM
- (CATALOG_ITEM_ID, TITLE, DESCRIPTION, PUBLISHER, RELEASE_DATE,
- TYPE) VALUES (5, 'La La Land', 'Musical', 'Summit Entertainment', TO_DATE('12/09/2016 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'DVD');
- INSERT INTO CATALOG_ITEM
- (CATALOG_ITEM_ID, TITLE, DESCRIPTION, PUBLISHER, RELEASE_DATE, TYPE)
- VALUES (4, 'Infinite Jest', 'Tragicomedy', 'Brown, Little, and Co.', TO_DATE('02/01/1996 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BOOK');
- INSERT INTO CATALOG_ITEM
- (CATALOG_ITEM_ID, TITLE, DESCRIPTION, PUBLISHER, RELEASE_DATE, TYPE)
- VALUES (9, 'The Name of the Wind, 'Fantasy', 'DAW Books', TO_DATE('03/27/2007 00:00:00', 'MM/DD/YYYY HH24:MI:S'), 'BOOK');
- Insert into CATALOG_ITEM
- (CATALOG_ITEM_ID, TITLE, DESCRIPTION, PUBLISHER, RELEASE_DATE, TYPE)
- Values (10, 'The Social Network, 'Drama', 'Columbia Pictures', TO_DATE('10/01/2010 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'DVD');
- /** BOOK*/
- INSERT INTO BOOK
- (ISBN, PAGES, CATALOG_ITEM_ID)
- VALUES ('9780765365279', 1280, 1);
- INSERT INTO BOOK
- (ISBN, PAGES, CATALOG_ITEM_ID)
- VALUES ('9780765365286', 1328, 2);
- INSERT INTO BOOK
- (ISBN, PAGES, CATALOG_ITEM_ID)
- VALUES ('9780316066525', 1079, 4);
- INSERT INTO BOOK
- (ISBN, PAGES, CATALOG_ITEM_ID)
- VALUES ('9780756404079', 722, 7);
- /** DVD */
- INSERT INTO DVD
- (LENGTH, CATALOG_ITEM_ID)
- VALUES ('2:28', 3);
- INSERT INTO DVD
- (LENGTH, CATALOG_ITEM_ID)
- VALUES ('2:01', 8);
- INSERT INTO DVD
- (LENGTH, CATALOG_ITEM_ID)
- VALUES ('1:34', 6);
- INSERT INTO DVD
- (LENGTH, CATALOG_ITEM_ID)
- VALUES ('2:08', 5);
- /**LIBRARY */
- INSERT INTO LIBRARY
- (LIBRARY_ID, LIBRARY_NAME, LIBRARY_PHONE, LIBRARY_ADDRESS)
- VALUES (1, 'New York Public Library', '212-555-2345', '476 5th Avenue, New York, NY');
- INSERT INTO LIBRARY
- (LIBRARY_ID, LIBRARY_NAME, LIBRARY_PHONE, LIBRARY_ADDRESS)
- VALUES (2, 'Baltimore County Library', '443-555-3456', '320 York Road, Towson, MD');
- INSERT INTO LIBRARY
- (LIBRARY_ID, LIBRARY_NAME, LIBRARY_PHONE, LIBRARY_ADDRESS)
- VALUES (3, 'UMUC Library', '240-684-2020', '1616 McCormick Dr, Largo, MD');
- /** CUSTOMER */
- INSERT INTO CUSTOMER
- (CUSTOMER_ID, CUSTOMER_FIRSTNAME, CUSTOMER_LASTNAME, CUSTOMER_STREET, CUSTOMER_CITY, CUSTOMER_STATE, CUSTOMER_ZIP)
- VALUES (1, 'Christian', 'Walker', '96 Clark Drive', 'Hicksville', 'NY', '11801');
- INSERT INTO CUSTOMER
- (CUSTOMER_ID, CUSTOMER_FIRSTNAME, CUSTOMER_LASTNAME, CUSTOMER_STREET, CUSTOMER_CITY, CUSTOMER_STATE, CUSTOMER_ZIP)
- VALUES(4, 'Emile', 'Cross', '387 Circle Ave', 'Vincentowne', 'NJ', '08088');
- INSERT INTO CUSTOMER
- (CUSTOMER_ID, CUSTOMER_FIRSTNAME, CUSTOMER_LASTNAME, CUSTOMER_STREET, CUSTOMER_CITY, CUSTOMER_STATE, CUSTOMER_ZIP)
- VALUES (2, 'Deena', 'Pilgrim', '838 Orange street', 'Frederick', 'MD', '21701');
- INSERT INTO CUSTOMER
- (CUSTOMER_ID, CUSTOMER_FIRSTNAME, CUSTOMER_LASTNAME, CUSTOMER_STREET, CUSTOMER_CITY, CUSTOMER_STATE, CUSTOMER_ZIP)
- VALUES (3, 'Calista', 'Secor', '9330 El Dorado Lane', 'Temple Hills’, ‘MD', '20748');
- INSERT INTO CUSTOMER
- (CUSTOMER_ID, CUSTOMER_FIRSTNAME, CUSTOMER_LASTNAME, CUSTOMER_STREET, CUSTOMER_CITY, CUSTOMER_STATE, CUSTOMER_ZIP)
- VALUES (5, 'Johnny', 'Royalle', '9948 Campfire Drive', 'East Elmhurst', 'NY', '11369');
- INSERT INTO CUSTOMER
- (CUSTOMER_ID, CUSTOMER_FIRSTNAME, CUSTOMER_LASTNAME, CUSTOMER_STREET, CUSTOMER_CITY, CUSTOMER_STATE, CUSTOMER_ZIP)
- VALUES (6, 'Harley', 'Cohen', '96 Vine Street', 'Bowie’, ‘MD', '20715');
- /**LIBRARY_CARD */
- INSERT INTO LIBRARY_CARD
- (LIBRARY_ID, CUSTOMER_ID, LIBRARY_CARD_ID, CARD_NUMBER, PIN,
- DATE_EXPIRE)
- VALUES (1, 4, 2, '33554432', '8192',
- TO_DATE('07/04/2020 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO LIBRARY_CARD
- (LIBRARY_ID, CUSTOMER_ID, LIBRARY_CARD_ID, CARD_NUMBER, PIN,
- DATE_EXPIRE)
- VALUES (1, 1, 1, '16777216', '1234',
- TO_DATE('12/31/2019 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO LIBRARY_CARD
- (LIBRARY_ID, CUSTOMER_ID, LIBRARY_CARD_ID, CARD_NUMBER, PIN,
- DATE_EXPIRE)
- VALUES (3, 6, 5, '65536128', '4711',
- TO_DATE('10/09/2019 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO LIBRARY_CARD
- (LIBRARY_ID, CUSTOMER_ID, LIBRARY_CARD_ID, CARD_NUMBER, PIN,
- DATE_EXPIRE)
- VALUES (2, 2, 3, '10485760', '88888',
- TO_DATE('02/29/2020 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO LIBRARY_CARD
- (LIBRARY_ID, CUSTOMER_ID, LIBRARY_CARD_ID, CARD_NUMBER, PIN, DATE_EXPIRE)
- VALUES (3, 4, 7, '16384512', '8192',
- TO_DATE('02/15/2020 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO LIBRARY_CARD
- (LIBRARY_ID, CUSTOMER_ID, LIBRARY_CARD_ID, CARD_NUMBER, PIN,
- DATE_EXPIRE)
- VALUES (3, 5, 6, '32768256', '8008',
- TO_DATE('03/11/2020 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO LIBRARY_CARD
- (LIBRARY_ID, CUSTOMER_ID, LIBRARY_CARD_ID, CARD_NUMBER, PIN,
- DATE_EXPIRE)
- VALUES (2, 3, 4, '20971520', '0911',
- TO_DATE('05/17/2021 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
- INSERT INTO LIBRARY_CARD
- (LIBRARY_ID, CUSTOMER_ID, LIBRARY_CARD_ID, CARD_NUMBER, PIN, DATE_EXPIRE)
- VALUES (3, 4, 7, '16384512', '8192',
- TO_DATE('02/15/2020 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
Editor
You can edit this paste and save as new: