REM script name: insert_customers.sql
REM Inserts values for CUSTOMERS table in the OE schema

REM
REM CUSTOMERS
REM

DELETE FROM customers WHERE
customer_id = 1001;

INSERT INTO customers VALUES 
    (1001,'Dennis','Green',
     cust_address_typ('1 Oracle Drive','03062','Nashua','NH','US'),
     PHONE_LIST_TYP('+1 603 897 4104'),
     'us','AMERICA','100','Dennis.Green@Oracle.com',
     149,
     MDSYS.SDO_GEOMETRY(2001, 8307, 
       MDSYS.SDO_POINT_TYPE (-63.13631, 52.485424,NULL),NULL,NULL),
     '01-JAN-60','married', 'M', '110,000 - 129,999');
    

DELETE FROM customers WHERE
customer_id = 1002;
    
INSERT INTO customers VALUES 
    (1002,'John','Smith',
     cust_address_typ('1910 Oracle Way','20190','Reston','VA','US'),
     PHONE_LIST_TYP('+1 703 364 4111'),
     'us','AMERICA','100','John.Smith@Oracle.com',
     149,
     MDSYS.SDO_GEOMETRY(2001, 8307, 
        MDSYS.SDO_POINT_TYPE(-70.120133, 44.795766,NULL),NULL,NULL), 
        '02-MAY-70', 'single', 'M', '70,000 - 89,999');

commit;