DELETE FROM ADDRESS;

INSERT INTO ADDRESS ( CUSTOMER_CODE, CUSTOMER_NAME, 
                      POST_CODE    , CUSTOMER_ADDRESS, 
                      CUSTOMER_TEL ) 
  VALUES(  '00000001', 
           'terasoluna1',
           '111-1234',
           '東京都中央区',
           '000-1234-1234');
           
INSERT INTO ADDRESS ( CUSTOMER_CODE, CUSTOMER_NAME, 
                      POST_CODE    , CUSTOMER_ADDRESS, 
                      CUSTOMER_TEL ) 
  VALUES(  '00000002', 
           '田中',
           '222-1234',
           '東京都中央区',
           '111-4567-8901');
           
INSERT INTO ADDRESS ( CUSTOMER_CODE, CUSTOMER_NAME, 
                      POST_CODE    , CUSTOMER_ADDRESS, 
                      CUSTOMER_TEL ) 
  VALUES(  '00000003', 
           '鈴木',
           '333-1234',
           '東京都中央区',
           '123-4567-1234');

INSERT INTO ADDRESS ( CUSTOMER_CODE, CUSTOMER_NAME, 
                      POST_CODE    , CUSTOMER_ADDRESS, 
                      CUSTOMER_TEL ) 
  VALUES(  '00000004', 
           '高橋',
           '444-1234',
           '千葉県成田市',
           '111-4567-8901');
           
INSERT INTO ADDRESS ( CUSTOMER_CODE, CUSTOMER_NAME, 
                      POST_CODE    , CUSTOMER_ADDRESS, 
                      CUSTOMER_TEL ) 
  VALUES(  '00000005', 
           '小池',
           '555-1234',
           '東京都中央区',
           '123-4567-1234');
           
INSERT INTO ADDRESS ( CUSTOMER_CODE, CUSTOMER_NAME, 
                      POST_CODE    , CUSTOMER_ADDRESS, 
                      CUSTOMER_TEL ) 
  VALUES(  '00000006', 
           '鈴木',
           '666-1234',
           '東京都足立区',
           '000-1234-1234');
           
INSERT INTO ADDRESS ( CUSTOMER_CODE, CUSTOMER_NAME, 
                      POST_CODE    , CUSTOMER_ADDRESS, 
                      CUSTOMER_TEL ) 
  VALUES(  '00000007', 
           '佐藤',
           '777-1234',
           '東京都国立市',
           '111-4567-8901');
           
INSERT INTO ADDRESS ( CUSTOMER_CODE, CUSTOMER_NAME, 
                      POST_CODE    , CUSTOMER_ADDRESS, 
                      CUSTOMER_TEL ) 
  VALUES(  '00000008', 
           '青木',
           '888-1234',
           '東京都渋谷区',
           '123-4567-1234');
 
INSERT INTO ADDRESS ( CUSTOMER_CODE, CUSTOMER_NAME, 
                      POST_CODE    , CUSTOMER_ADDRESS, 
                      CUSTOMER_TEL ) 
  VALUES(  '00000009', 
           '山本',
           '999-1234',
           '東京都中野区',
           '111-4567-8901');
           
INSERT INTO ADDRESS ( CUSTOMER_CODE, CUSTOMER_NAME, 
                      POST_CODE    , CUSTOMER_ADDRESS, 
                      CUSTOMER_TEL ) 
  VALUES(  '00000010', 
           '山下',
           '000-1234',
           '東京都三鷹市',
           '123-4567-1234');
           
COMMIT;
