------------------------------------------------------------------------
-- DISCLAIMER:
--    This script is provided for educational purposes only. It is NOT
--	supported by Oracle World Wide Technical Support.
--    The script has been tested and appears to work as intended.
--	You should always run new scripts on a test instance initially.
--
------------------------------------------------------------------------
SET DEFINE OFF;
Insert into EAST.BRANCH
   (BRANCH_ID, BRANCH_STREET_TYPE, BRANCH_STREET_NAME, BRANCH_STREET_NUMBER, BRANCH_LEVEL, BRANCH_CI
TY, BRANCH_STATE, BRANCH_COUNTRY, BRANCH_SIZE, BRANCH_OPENED, ZIP_CODE, BRANCH_NAME)
 Values
   ('6', 'Avenue', 'Malesuada', '409', 8, 
    'Casper', 'SC', 'United States', 'MEDIUM', TO_DATE('12/16/2004 00:00:00', 'MM/DD/YYYY HH24:MI:SS
'), 
    '86149', 'Saturn');
Insert into EAST.BRANCH
   (BRANCH_ID, BRANCH_STREET_TYPE, BRANCH_STREET_NAME, BRANCH_STREET_NUMBER, BRANCH_LEVEL, BRANCH_CI
TY, BRANCH_STATE, BRANCH_COUNTRY, BRANCH_SIZE, BRANCH_OPENED, ZIP_CODE, BRANCH_NAME)
 Values
   ('7', 'Street', 'Eget', '2047', 6, 
    'Jacksonville', 'ME', 'United States', 'MEDIUM', TO_DATE('06/27/2006 00:00:00', 'MM/DD/YYYY HH24
:MI:SS'), 
    '66803', 'Neptune');
Insert into EAST.BRANCH
   (BRANCH_ID, BRANCH_STREET_TYPE, BRANCH_STREET_NAME, BRANCH_STREET_NUMBER, BRANCH_LEVEL, BRANCH_CI
TY, BRANCH_STATE, BRANCH_COUNTRY, BRANCH_SIZE, BRANCH_OPENED, ZIP_CODE, BRANCH_NAME)
 Values
   ('8', 'Street', 'Suspendisse', '390', 5, 
    'Cambridge', 'Ohio', 'United States', 'SMALL', TO_DATE('02/21/2006 00:00:00', 'MM/DD/YYYY HH24:M
I:SS'), 
    '62482', 'Earth');
Insert into EAST.BRANCH
   (BRANCH_ID, BRANCH_STREET_TYPE, BRANCH_STREET_NAME, BRANCH_STREET_NUMBER, BRANCH_LEVEL, BRANCH_CI
TY, BRANCH_STATE, BRANCH_COUNTRY, BRANCH_SIZE, BRANCH_OPENED, ZIP_CODE, BRANCH_NAME)
 Values
   ('9', 'Plaza', 'Cambridge', '147', 1, 
    'Beverly', 'CO', 'United States', 'SMALL', TO_DATE('09/20/2009 00:00:00', 'MM/DD/YYYY HH24:MI:SS
'), 
    '52669', 'Moon');
Insert into EAST.BRANCH
   (BRANCH_ID, BRANCH_STREET_TYPE, BRANCH_STREET_NAME, BRANCH_STREET_NUMBER, BRANCH_LEVEL, BRANCH_CI
TY, BRANCH_STATE, BRANCH_COUNTRY, BRANCH_SIZE, BRANCH_OPENED, ZIP_CODE, BRANCH_NAME)
 Values
   ('10', 'Avenue', 'Gravida', '1272', 2, 
    'Orem', 'KS', 'United States', 'SMALL', TO_DATE('03/11/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'),
 
    '95903', 'Pluto');
COMMIT;
