Oracle Analytics Cloud：お試し用にAutonomous Data Warehouseで、SHスキーマをもとにSHJPスキーマを作成する

はじめに
---
Oracle Analytics Cloudをいろいろ試すために、Autonomous Data Warehouseサービスを作成すると入っているSHスキーマをもとにしてSHJPスキーマを作成します。※本記事ではAutonomous Data Warehouseサービスの作成済みであることを前提としています。

Autonomous Data Warehouseサービスへのアクセス
---
SHJPスキーマを作成するため、データベース・アクションを使用します。OCI管理コンソールにログインします。作成済のAutonomous Data Warehouseサービスを開きます。
データベース・アクションをクリックします
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2516153/02df8315-b6a2-e63a-56fb-e13b637f4420.png)


SQLの実行
---
SQLをクリックします
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2516153/4d21cf4f-487f-97fa-08d3-9d041934d650.png)

下部にある作成用スクリプトの▼アイコンで展開し、
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2516153/5a63c92f-a10a-260d-78e2-dfa295f8c787.png)

全て選択してコピーし、データベースアクションのSQLに貼り付けます。すごく多いです。
![{5DB2ECAB-E045-4E79-BEA6-90E21F38D16E}.tmp.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2516153/3e1c7d9a-4774-d89d-571c-45079a77f491.png)

スクリプトの実行をクリックします。
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2516153/8dd878aa-e91b-bf54-8342-d3d8f5bb8b6d.png)

下部にステータスが表示されます。ひたすら待ちます。
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2516153/8f045024-d109-f543-85b4-fd452268b888.png)

以下、結果が出力されると完了です。
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2516153/94c40222-ad57-8706-602d-be79bb6bf684.png)
※本記事記載の時点では、7、8分かかりました。

ウォレットファイルのダウンロード
---
Oracle Analytics Cloud(OAC)から接続するのに必要なウォレットファイルをダウンロードしておきます。Autonomous Data WarehouseサービスのDB接続をクリックします。
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2516153/2d0409ed-1e37-761a-5899-8a1096bba0de.png)

ウォレットのダウンロードをクリックします。
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2516153/c9a34c3f-d60e-55ed-cd8d-d9cea16f3e04.png)

パスワードを入力します。ダウンロードをクリックします。
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2516153/dbef63df-09a4-ce61-ec9f-ef45b27633ef.png)

\<ADBサービス名\>_wallet.zipというファイル名でダウンロードされますので保存しておきます。


作成用スクリプト
---
<details><summary>作成用スクリプトはこちら</summary>

~~~shjp.sql
create user shjp identified by Welcome1234##;
grant dwrole to shjp;
alter user shjp quota unlimited on DATA;

-- create table shjp.channels as select * from sh.channels;
-- create table shjp.costs as select * from sh.costs;
-- create table shjp.countries as select * from sh.countries;
-- create table shjp.customers as select * from sh.customers;
-- create table shjp.products as select * from sh.products;
-- create table shjp.promotions as select * from sh.promotions;
-- create table shjp.sales as select * from sh.sales;
-- create table shjp.times as select * from sh.times;

DROP TABLE "SHJP"."TIMES" PURGE;
CREATE TABLE "SHJP"."TIMES" 
   (	"TIME_ID" DATE NOT NULL , 
	"DAY_NAME" VARCHAR2(9 BYTE) COLLATE "USING_NLS_COMP" NOT NULL, 
	"DAY_NUMBER_IN_WEEK" NUMBER(1,0) NOT NULL , 
	"DAY_NUMBER_IN_MONTH" NUMBER(2,0) NOT NULL , 
	"CALENDAR_WEEK_NUMBER" NUMBER(2,0) NOT NULL , 
	"FISCAL_WEEK_NUMBER" NUMBER(2,0) NOT NULL , 
	"WEEK_ENDING_DAY" DATE NOT NULL , 
	"WEEK_ENDING_DAY_ID" NUMBER NOT NULL , 
	"CALENDAR_MONTH_NUMBER" NUMBER(2,0) NOT NULL , 
	"FISCAL_MONTH_NUMBER" NUMBER(2,0) NOT NULL , 
	"CALENDAR_MONTH_DESC" VARCHAR2(12 BYTE) COLLATE "USING_NLS_COMP" NOT NULL,
	"CALENDAR_MONTH_ID" NUMBER NOT NULL , 
	"FISCAL_MONTH_DESC" VARCHAR2(12 BYTE) COLLATE "USING_NLS_COMP" NOT NULL, 
	"FISCAL_MONTH_ID" NUMBER NOT NULL , 
	"DAYS_IN_CAL_MONTH" NUMBER NOT NULL , 
	"DAYS_IN_FIS_MONTH" NUMBER NOT NULL , 
	"END_OF_CAL_MONTH" DATE NOT NULL , 
	"END_OF_FIS_MONTH" DATE NOT NULL , 
	"CALENDAR_MONTH_NAME" VARCHAR2(9 BYTE) COLLATE "USING_NLS_COMP" NOT NULL, 
	"FISCAL_MONTH_NAME" VARCHAR2(9 BYTE) COLLATE "USING_NLS_COMP" NOT NULL, 
	"CALENDAR_QUARTER_DESC" CHAR(7 BYTE) COLLATE "USING_NLS_COMP" NOT NULL, 
	"CALENDAR_QUARTER_ID" NUMBER NOT NULL , 
	"FISCAL_QUARTER_DESC" CHAR(7 BYTE) COLLATE "USING_NLS_COMP" NOT NULL, 
	"FISCAL_QUARTER_ID" NUMBER NOT NULL , 
	"DAYS_IN_CAL_QUARTER" NUMBER NOT NULL , 
	"DAYS_IN_FIS_QUARTER" NUMBER NOT NULL , 
	"END_OF_CAL_QUARTER" DATE NOT NULL , 
	"END_OF_FIS_QUARTER" DATE NOT NULL , 
	"CALENDAR_QUARTER_NUMBER" NUMBER(1,0) NOT NULL , 
	"FISCAL_QUARTER_NUMBER" NUMBER(1,0) NOT NULL , 
	"CALENDAR_YEAR" NUMBER(4,0) NOT NULL , 
	"CALENDAR_YEAR_ID" NUMBER NOT NULL , 
	"FISCAL_YEAR" NUMBER(4,0) NOT NULL , 
	"FISCAL_YEAR_ID" NUMBER NOT NULL , 
	"DAYS_IN_CAL_YEAR" NUMBER NOT NULL , 
	"DAYS_IN_FIS_YEAR" NUMBER NOT NULL , 
	"END_OF_CAL_YEAR" DATE NOT NULL , 
	"END_OF_FIS_YEAR" DATE NOT NULL 
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

ALTER TABLE "SHJP"."TIMES" ADD CONSTRAINT "TIMES_PK" PRIMARY KEY ("TIME_ID") RELY DISABLE;


DROP TABLE "SHJP"."CHANNELS" PURGE;
CREATE TABLE "SHJP"."CHANNELS" 
   (	"CHANNEL_ID" NUMBER NOT NULL, 
	"CHANNEL_DESC" VARCHAR2(20 BYTE) COLLATE "USING_NLS_COMP" NOT NULL , 
	"CHANNEL_CLASS" VARCHAR2(20 BYTE) COLLATE "USING_NLS_COMP" NOT NULL , 
	"CHANNEL_CLASS_ID" NUMBER  NOT NULL, 
	"CHANNEL_TOTAL" VARCHAR2(13 BYTE) COLLATE "USING_NLS_COMP" NOT NULL , 
	"CHANNEL_TOTAL_ID" NUMBER  NOT NULL
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

ALTER TABLE "SHJP"."CHANNELS" ADD CONSTRAINT "CHANNELS_PK" PRIMARY KEY ("CHANNEL_ID") RELY DISABLE;



DROP TABLE "SHJP"."COUNTRIES" PURGE;
CREATE TABLE "SHJP"."COUNTRIES" 
   (	"COUNTRY_ID" NUMBER NOT NULL, 
	"COUNTRY_ISO_CODE" CHAR(2 BYTE) COLLATE "USING_NLS_COMP" NOT NULL , 
	"COUNTRY_NAME" VARCHAR2(40 BYTE) COLLATE "USING_NLS_COMP" NOT NULL , 
	"COUNTRY_SUBREGION" VARCHAR2(30 BYTE) COLLATE "USING_NLS_COMP" NOT NULL , 
	"COUNTRY_SUBREGION_ID" NUMBER NOT NULL, 
	"COUNTRY_REGION" VARCHAR2(20 BYTE) COLLATE "USING_NLS_COMP" NOT NULL , 
	"COUNTRY_REGION_ID" NUMBER NOT NULL, 
	"COUNTRY_TOTAL" VARCHAR2(11 BYTE) COLLATE "USING_NLS_COMP" NOT NULL , 
	"COUNTRY_TOTAL_ID" NUMBER NOT NULL, 
	"COUNTRY_NAME_HIST" VARCHAR2(40 BYTE) COLLATE "USING_NLS_COMP"
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

ALTER TABLE "SHJP"."COUNTRIES" ADD CONSTRAINT "COUNTRIES_PK" PRIMARY KEY ("COUNTRY_ID") RELY DISABLE;


DROP TABLE "SHJP"."PRODUCTS" PURGE;
CREATE TABLE "SHJP"."PRODUCTS" 
   (	"PROD_ID" NUMBER(6,0)  NOT NULL , 
	"PROD_NAME" VARCHAR2(50 BYTE)  COLLATE "USING_NLS_COMP" NOT NULL , 
	"PROD_DESC" VARCHAR2(4000 BYTE)  COLLATE "USING_NLS_COMP" NOT NULL , 
	"PROD_SUBCATEGORY" VARCHAR2(50 BYTE)  COLLATE "USING_NLS_COMP" NOT NULL , 
	"PROD_SUBCATEGORY_ID" NUMBER NOT NULL , 
	"PROD_SUBCATEGORY_DESC" VARCHAR2(2000 BYTE)  COLLATE "USING_NLS_COMP" NOT NULL , 
	"PROD_CATEGORY" VARCHAR2(50 BYTE)  COLLATE "USING_NLS_COMP" NOT NULL , 
	"PROD_CATEGORY_ID" NUMBER NOT NULL , 
	"PROD_CATEGORY_DESC" VARCHAR2(2000 BYTE) COLLATE "USING_NLS_COMP" NOT NULL , 
	"PROD_WEIGHT_CLASS" NUMBER(3,0) NOT NULL , 
	"PROD_UNIT_OF_MEASURE" VARCHAR2(20 BYTE) COLLATE "USING_NLS_COMP", 
	"PROD_PACK_SIZE" VARCHAR2(30 BYTE) COLLATE "USING_NLS_COMP" NOT NULL , 
	"SUPPLIER_ID" NUMBER(6,0) NOT NULL , 
	"PROD_STATUS" VARCHAR2(20 BYTE) COLLATE "USING_NLS_COMP" NOT NULL , 
	"PROD_LIST_PRICE" NUMBER(8,2) NOT NULL , 
	"PROD_MIN_PRICE" NUMBER(8,2) NOT NULL , 
	"PROD_TOTAL" VARCHAR2(13 BYTE) COLLATE "USING_NLS_COMP" NOT NULL , 
	"PROD_TOTAL_ID" NUMBER NOT NULL , 
	"PROD_SRC_ID" NUMBER, 
	"PROD_EFF_FROM" DATE, 
	"PROD_EFF_TO" DATE, 
	"PROD_VALID" VARCHAR2(1 BYTE) COLLATE "USING_NLS_COMP"
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

ALTER TABLE "SHJP"."PRODUCTS" ADD CONSTRAINT "PRODUCTS_PK" PRIMARY KEY ("PROD_ID") RELY DISABLE;


DROP TABLE "SHJP"."CUSTOMERS" PURGE;
CREATE TABLE "SHJP"."CUSTOMERS" 
   (	"CUST_ID" NUMBER NOT NULL , 
	"CUST_FIRST_NAME" VARCHAR2(20 BYTE) COLLATE "USING_NLS_COMP" NOT NULL , 
	"CUST_LAST_NAME" VARCHAR2(40 BYTE) COLLATE "USING_NLS_COMP" NOT NULL , 
	"CUST_GENDER" CHAR(1 BYTE)  COLLATE "USING_NLS_COMP" NOT NULL , 
	"CUST_YEAR_OF_BIRTH" NUMBER(4,0) NOT NULL , 
	"CUST_MARITAL_STATUS" VARCHAR2(20 BYTE) COLLATE "USING_NLS_COMP", 
	"CUST_STREET_ADDRESS" VARCHAR2(40 BYTE) COLLATE "USING_NLS_COMP" NOT NULL , 
	"CUST_POSTAL_CODE" VARCHAR2(10 BYTE) COLLATE "USING_NLS_COMP" NOT NULL , 
	"CUST_CITY" VARCHAR2(30 BYTE) COLLATE "USING_NLS_COMP" NOT NULL , 
	"CUST_CITY_ID" NUMBER NOT NULL , 
	"CUST_STATE_PROVINCE" VARCHAR2(40 BYTE) COLLATE "USING_NLS_COMP" NOT NULL , 
	"CUST_STATE_PROVINCE_ID" NUMBER NOT NULL , 
	"COUNTRY_ID" NUMBER NOT NULL , 
	"CUST_MAIN_PHONE_NUMBER" VARCHAR2(25 BYTE) COLLATE "USING_NLS_COMP" NOT NULL , 
	"CUST_INCOME_LEVEL" VARCHAR2(30 BYTE) COLLATE "USING_NLS_COMP", 
	"CUST_CREDIT_LIMIT" NUMBER, 
	"CUST_EMAIL" VARCHAR2(50 BYTE) COLLATE "USING_NLS_COMP", 
	"CUST_TOTAL" VARCHAR2(14 BYTE) COLLATE "USING_NLS_COMP" NOT NULL , 
	"CUST_TOTAL_ID" NUMBER NOT NULL , 
	"CUST_SRC_ID" NUMBER, 
	"CUST_EFF_FROM" DATE, 
	"CUST_EFF_TO" DATE, 
	"CUST_VALID" VARCHAR2(1 BYTE) COLLATE "USING_NLS_COMP"
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

ALTER TABLE "SHJP"."CUSTOMERS" ADD CONSTRAINT "CUSTOMERS_PK" PRIMARY KEY ("CUST_ID") RELY DISABLE;
ALTER TABLE "SHJP"."CUSTOMERS" ADD CONSTRAINT "CUSTOMERS_COUNTRY_FK" FOREIGN KEY ("COUNTRY_ID") REFERENCES "SHJP"."COUNTRIES" ("COUNTRY_ID") RELY DISABLE;


DROP TABLE "SHJP"."PROMOTIONS" PURGE;
CREATE TABLE "SHJP"."PROMOTIONS" 
   (	"PROMO_ID" NUMBER(6,0) NOT NULL , 
	"PROMO_NAME" VARCHAR2(30 BYTE) COLLATE "USING_NLS_COMP" NOT NULL , 
	"PROMO_SUBCATEGORY" VARCHAR2(30 BYTE) COLLATE "USING_NLS_COMP" NOT NULL , 
	"PROMO_SUBCATEGORY_ID" NUMBER NOT NULL , 
	"PROMO_CATEGORY" VARCHAR2(30 BYTE) COLLATE "USING_NLS_COMP" NOT NULL , 
	"PROMO_CATEGORY_ID" NUMBER NOT NULL , 
	"PROMO_COST" NUMBER(10,2) NOT NULL , 
	"PROMO_BEGIN_DATE" DATE NOT NULL , 
	"PROMO_END_DATE" DATE NOT NULL , 
	"PROMO_TOTAL" VARCHAR2(15 BYTE) COLLATE "USING_NLS_COMP" NOT NULL , 
	"PROMO_TOTAL_ID" NUMBER NOT NULL 
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

ALTER TABLE "SHJP"."PROMOTIONS" ADD CONSTRAINT "PROMO_PK" PRIMARY KEY ("PROMO_ID") RELY DISABLE;




DROP TABLE "SHJP"."COSTS" PURGE;
CREATE TABLE "SHJP"."COSTS"
   (	"PROD_ID" NUMBER NOT NULL , 
	"TIME_ID" DATE NOT NULL , 
	"PROMO_ID" NUMBER NOT NULL , 
	"CHANNEL_ID" NUMBER NOT NULL , 
	"UNIT_COST" NUMBER(10,2) NOT NULL , 
	"UNIT_PRICE" NUMBER(10,2) NOT NULL 
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

ALTER TABLE "SHJP"."COSTS" ADD CONSTRAINT "COSTS_PROMO_FK" FOREIGN KEY ("PROMO_ID") REFERENCES "SHJP"."PROMOTIONS" ("PROMO_ID") RELY DISABLE;
ALTER TABLE "SHJP"."COSTS" ADD CONSTRAINT "COSTS_CHANNEL_FK" FOREIGN KEY ("CHANNEL_ID") REFERENCES "SHJP"."CHANNELS" ("CHANNEL_ID") RELY DISABLE;
ALTER TABLE "SHJP"."COSTS" ADD CONSTRAINT "COSTS_PRODUCT_FK" FOREIGN KEY ("PROD_ID") REFERENCES "SHJP"."PRODUCTS" ("PROD_ID") RELY DISABLE;
ALTER TABLE "SHJP"."COSTS" ADD CONSTRAINT "COSTS_TIME_FK" FOREIGN KEY ("TIME_ID") REFERENCES "SHJP"."TIMES" ("TIME_ID") RELY DISABLE;


DROP TABLE "SHJP"."SALES" PURGE;
CREATE TABLE "SHJP"."SALES" 
   (	"PROD_ID" NUMBER NOT NULL, 
	"CUST_ID" NUMBER NOT NULL, 
	"TIME_ID" DATE  NOT NULL, 
	"CHANNEL_ID" NUMBER  NOT NULL, 
	"PROMO_ID" NUMBER  NOT NULL, 
	"QUANTITY_SOLD" NUMBER(10,2)  NOT NULL, 
	"AMOUNT_SOLD" NUMBER(10,2)  NOT NULL
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

ALTER TABLE "SHJP"."SALES" ADD CONSTRAINT "SALES_PROMO_FK" FOREIGN KEY ("PROMO_ID") REFERENCES "SHJP"."PROMOTIONS" ("PROMO_ID") RELY DISABLE;
ALTER TABLE "SHJP"."SALES" ADD CONSTRAINT "SALES_PRODUCT_FK" FOREIGN KEY ("PROD_ID") REFERENCES "SHJP"."PRODUCTS" ("PROD_ID") RELY DISABLE;
ALTER TABLE "SHJP"."SALES" ADD CONSTRAINT "SALES_CUSTOMER_FK" FOREIGN KEY ("CUST_ID") REFERENCES "SHJP"."CUSTOMERS" ("CUST_ID") RELY DISABLE;
ALTER TABLE "SHJP"."SALES" ADD CONSTRAINT "SALES_CHANNEL_FK" FOREIGN KEY ("CHANNEL_ID") REFERENCES "SHJP"."CHANNELS" ("CHANNEL_ID") RELY DISABLE;
ALTER TABLE "SHJP"."SALES" ADD CONSTRAINT "SALES_TIME_FK" FOREIGN KEY ("TIME_ID") REFERENCES "SHJP"."TIMES" ("TIME_ID") RELY DISABLE;


-- #################################################
-- #                                               #
-- #  From En To Jp                                #
-- #                                               #
-- #################################################


-- *************************************************
--   CHANNELS
-- *************************************************

INSERT INTO SHJP.CHANNELS SELECT * FROM SH.CHANNELS;

ALTER TABLE SHJP.CHANNELS MODIFY (
 CHANNEL_DESC  VARCHAR2(30),
 CHANNEL_CLASS VARCHAR2(20),
 CHANNEL_TOTAL VARCHAR2(20));

UPDATE SHJP.CHANNELS SET CHANNEL_DESC = 'パートナー', CHANNEL_CLASS = 'その他' WHERE CHANNEL_ID = 2;
UPDATE SHJP.CHANNELS SET CHANNEL_DESC = '直営', CHANNEL_CLASS = '直販' WHERE CHANNEL_ID = 3;
UPDATE SHJP.CHANNELS SET CHANNEL_DESC = 'インターネット', CHANNEL_CLASS = '間接' WHERE CHANNEL_ID = 4;
UPDATE SHJP.CHANNELS SET CHANNEL_DESC = 'カタログ', CHANNEL_CLASS = '間接' WHERE CHANNEL_ID = 5;
UPDATE SHJP.CHANNELS SET CHANNEL_DESC = '電話', CHANNEL_CLASS = '直販' WHERE CHANNEL_ID = 9;
UPDATE SHJP.CHANNELS SET CHANNEL_TOTAL = '全チャネル';

COMMIT;


-- *************************************************
--   CUSTOMERS
-- *************************************************


INSERT INTO SHJP.CUSTOMERS SELECT * FROM SH.CUSTOMERS;

UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美菜子'	,CUST_LAST_NAME ='増岡'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 30781;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博規'	,CUST_LAST_NAME ='伊藤'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 17448;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='ひかり'	,CUST_LAST_NAME ='山野'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 24560;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='義徳'	,CUST_LAST_NAME ='阿川'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 30782;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='岳'	,CUST_LAST_NAME ='愛川'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 17449;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博幸'	,CUST_LAST_NAME ='安達'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 24561;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='康子'	,CUST_LAST_NAME ='安部'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 37010;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='加奈'	,CUST_LAST_NAME ='安部'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 23677;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='史子'	,CUST_LAST_NAME ='伊集院'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 30787;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真季'	,CUST_LAST_NAME ='伊藤'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 17454;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='淳平'	,CUST_LAST_NAME ='伊藤'	,CUST_GENDER ='M'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 37899;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='義弘'	,CUST_LAST_NAME ='伊藤'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 43239;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美智子'	,CUST_LAST_NAME ='吉田'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 37017;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='今日子'	,CUST_LAST_NAME ='吉田'	,CUST_GENDER ='F'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 44127;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='佳美'	,CUST_LAST_NAME ='宍戸'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 23684;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='聡美'	,CUST_LAST_NAME ='柴崎'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 29911;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='嘉則'	,CUST_LAST_NAME ='酒井'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 43244;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='香菜'	,CUST_LAST_NAME ='秋山'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 36140;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='景子'	,CUST_LAST_NAME ='須藤'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 43251;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='剛史'	,CUST_LAST_NAME ='清水'	,CUST_GENDER ='M'	,CUST_CITY ='北九州'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 47029;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='正平'	,CUST_LAST_NAME ='清水'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 15446;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='伸子'	,CUST_LAST_NAME ='石井'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 42367;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='敬之'	,CUST_LAST_NAME ='浅見'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 46145;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='幸夫'	,CUST_LAST_NAME ='相川'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 8605;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真'	,CUST_LAST_NAME ='相澤'	,CUST_GENDER ='M'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 49247;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勇気'	,CUST_LAST_NAME ='大崎'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 36557;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='孝子'	,CUST_LAST_NAME ='津村'	,CUST_GENDER ='F'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 8604;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勇斗'	,CUST_LAST_NAME ='田才'	,CUST_GENDER ='M'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 49236;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='努'	,CUST_LAST_NAME ='田村'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 35446;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='紀之'	,CUST_LAST_NAME ='田村'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 14839;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='達哉'	,CUST_LAST_NAME ='筒井'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 45669;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='直弼'	,CUST_LAST_NAME ='二見'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 46172;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='義之'	,CUST_LAST_NAME ='尾崎'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 46173;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='琢哉'	,CUST_LAST_NAME ='浜田'	,CUST_GENDER ='M'	,CUST_CITY ='東京'	,CUST_STATE_PROVINCE ='東京'	WHERE CUST_ID = 17506;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='伊織'	,CUST_LAST_NAME ='富田'	,CUST_GENDER ='M'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 21062;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博'	,CUST_LAST_NAME ='木下'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 8630;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='千鶴'	,CUST_LAST_NAME ='龝山'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 43946;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='治朗'	,CUST_LAST_NAME ='愛川'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 2409;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='志哲'	,CUST_LAST_NAME ='愛川'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 27297;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='浩樹'	,CUST_LAST_NAME ='伊藤'	,CUST_GENDER ='M'	,CUST_CITY ='北九州'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 34409;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='浩太'	,CUST_LAST_NAME ='岩手'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 43935;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='冬至'	,CUST_LAST_NAME ='吉田'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 2408;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博司'	,CUST_LAST_NAME ='吉田'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 27296;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='純也'	,CUST_LAST_NAME ='吉田'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 8629;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='祐太郎'	,CUST_LAST_NAME ='吉田'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 2404;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='司'	,CUST_LAST_NAME ='金井'	,CUST_GENDER ='M'	,CUST_CITY ='東京'	,CUST_STATE_PROVINCE ='東京'	WHERE CUST_ID = 23737;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='玲菜'	,CUST_LAST_NAME ='桑内'	,CUST_GENDER ='F'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 27292;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='順平'	,CUST_LAST_NAME ='戸川'	,CUST_GENDER ='M'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 33522;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='義啓'	,CUST_LAST_NAME ='広瀬'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 43979;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='貴子'	,CUST_LAST_NAME ='荒井'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 14856;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='伸子'	,CUST_LAST_NAME ='嵯峨'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 13987;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='千恵'	,CUST_LAST_NAME ='山本'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 21098;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='明充'	,CUST_LAST_NAME ='小沢'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 27320;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='慎吾'	,CUST_LAST_NAME ='小林'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 14861;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='菜穂子'	,CUST_LAST_NAME ='松井'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 21086;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美紀'	,CUST_LAST_NAME ='成田'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 13989;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='義之'	,CUST_LAST_NAME ='西田'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 1531;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='結城'	,CUST_LAST_NAME ='西田'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 45139;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='浩二'	,CUST_LAST_NAME ='青山'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 48918;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美貴'	,CUST_LAST_NAME ='石井'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 48938;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='桂'	,CUST_LAST_NAME ='石井'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 32683;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='隆司'	,CUST_LAST_NAME ='石川'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 38906;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='伸一'	,CUST_LAST_NAME ='石川'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 17803;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='太陽'	,CUST_LAST_NAME ='石川'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 38911;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='まなみ'	,CUST_LAST_NAME ='赤羽'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 18125;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='薫'	,CUST_LAST_NAME ='相川'	,CUST_GENDER ='F'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 49826;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='健二'	,CUST_LAST_NAME ='足立'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 17604;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由実'	,CUST_LAST_NAME ='谷口'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 26449;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='信吾'	,CUST_LAST_NAME ='藤井'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 33560;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美季'	,CUST_LAST_NAME ='栃尾'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 39782;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='裕樹'	,CUST_LAST_NAME ='平野'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 39787;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='知恵'	,CUST_LAST_NAME ='野間'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 14860;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由紀'	,CUST_LAST_NAME ='和田'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 27319;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='信二'	,CUST_LAST_NAME ='龝山'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 26444;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='弘美'	,CUST_LAST_NAME ='阿部'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 33555;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='康子'	,CUST_LAST_NAME ='安西'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 39777;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='武雄'	,CUST_LAST_NAME ='安部'	,CUST_GENDER ='M'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 39752;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='恭司'	,CUST_LAST_NAME ='安部'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 14864;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='史郎'	,CUST_LAST_NAME ='伊藤'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 5145;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='隆司'	,CUST_LAST_NAME ='岩橋'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 13986;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由希子'	,CUST_LAST_NAME ='菊地'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 21097;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='夕子'	,CUST_LAST_NAME ='吉田'	,CUST_GENDER ='F'	,CUST_CITY ='北九州'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 40638;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='次郎'	,CUST_LAST_NAME ='吉田'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 1528;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由佳'	,CUST_LAST_NAME ='吉田'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 8638;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='浩介'	,CUST_LAST_NAME ='近森'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 33527;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='誠司'	,CUST_LAST_NAME ='柴田'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 20220;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='多香子'	,CUST_LAST_NAME ='小林'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 18136;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='篤'	,CUST_LAST_NAME ='松井'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 17605;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='聡史'	,CUST_LAST_NAME ='松永'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 48939;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由香'	,CUST_LAST_NAME ='松倉'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 1527;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='玲菜'	,CUST_LAST_NAME ='新藤'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 8637;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博美'	,CUST_LAST_NAME ='西川'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 33526;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='卓也'	,CUST_LAST_NAME ='西脇'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 27322;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='慎吾'	,CUST_LAST_NAME ='石井'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 8633;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='恒'	,CUST_LAST_NAME ='石原'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 20222;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美貴'	,CUST_LAST_NAME ='石野'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 32676;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美菜子'	,CUST_LAST_NAME ='相澤'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 33553;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='祐太郎'	,CUST_LAST_NAME ='足立'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 39775;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='三郎'	,CUST_LAST_NAME ='村西'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 26448;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='沙織'	,CUST_LAST_NAME ='村尾'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 33559;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='公子'	,CUST_LAST_NAME ='大場'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 39781;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='孝子'	,CUST_LAST_NAME ='大場'	,CUST_GENDER ='F'	,CUST_CITY ='東京'	,CUST_STATE_PROVINCE ='東京'	WHERE CUST_ID = 44524;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由美子'	,CUST_LAST_NAME ='大塚'	,CUST_GENDER ='F'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 48911;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真季子'	,CUST_LAST_NAME ='大迫'	,CUST_GENDER ='F'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 40666;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='恵美子'	,CUST_LAST_NAME ='丹下'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 23861;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='明良'	,CUST_LAST_NAME ='池田'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 42527;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='明俊'	,CUST_LAST_NAME ='天童'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 10527;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='公雄'	,CUST_LAST_NAME ='田巻'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 17638;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由香'	,CUST_LAST_NAME ='田口'	,CUST_GENDER ='F'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 30062;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='孝司'	,CUST_LAST_NAME ='田畑'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 9369;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='雄介'	,CUST_LAST_NAME ='道下'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 42544;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='浩一'	,CUST_LAST_NAME ='尾崎'	,CUST_GENDER ='M'	,CUST_CITY ='東京'	,CUST_STATE_PROVINCE ='東京'	WHERE CUST_ID = 26505;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='武子'	,CUST_LAST_NAME ='富田'	,CUST_GENDER ='F'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 30061;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美穂'	,CUST_LAST_NAME ='富田'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 36319;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='治朗'	,CUST_LAST_NAME ='福島'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 41676;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='平祐'	,CUST_LAST_NAME ='阿部'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 42559;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='夕美'	,CUST_LAST_NAME ='愛甲'	,CUST_GENDER ='F'	,CUST_CITY ='北九州'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 46337;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='昌二郎'	,CUST_LAST_NAME ='愛川'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 42555;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='孝子'	,CUST_LAST_NAME ='安西'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 35444;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由香'	,CUST_LAST_NAME ='安達'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 35449;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='広喜'	,CUST_LAST_NAME ='伊沢'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 22986;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='貴子'	,CUST_LAST_NAME ='伊藤'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 30098;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='賢治'	,CUST_LAST_NAME ='園田'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 36320;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='平治'	,CUST_LAST_NAME ='横倉'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 50838;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='篤'	,CUST_LAST_NAME ='近森'	,CUST_GENDER ='M'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 39061;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='秀樹'	,CUST_LAST_NAME ='金子'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 14172;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真澄'	,CUST_LAST_NAME ='高岡'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 1684;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勇夫'	,CUST_LAST_NAME ='阪谷'	,CUST_GENDER ='M'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 7911;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博隆'	,CUST_LAST_NAME ='鹿野'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 22988;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勝信'	,CUST_LAST_NAME ='篠原'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 23860;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博'	,CUST_LAST_NAME ='小川'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 23864;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='大'	,CUST_LAST_NAME ='小林'	,CUST_GENDER ='M'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 30974;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='宣雄'	,CUST_LAST_NAME ='松村'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 48070;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='健之'	,CUST_LAST_NAME ='新井'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 45455;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='学'	,CUST_LAST_NAME ='石井'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 4300;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美樹'	,CUST_LAST_NAME ='石井'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 11395;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='多嘉子'	,CUST_LAST_NAME ='石川'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 35450;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由紀'	,CUST_LAST_NAME ='赤羽'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 17630;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='淳司'	,CUST_LAST_NAME ='前田'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 9358;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='基弘'	,CUST_LAST_NAME ='相川'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 17629;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩'	,CUST_LAST_NAME ='相川'	,CUST_GENDER ='F'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 36297;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='正樹'	,CUST_LAST_NAME ='足立'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 17625;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='敏也'	,CUST_LAST_NAME ='谷川'	,CUST_GENDER ='M'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 36292;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='聡美'	,CUST_LAST_NAME ='中山'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 5173;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='剛史'	,CUST_LAST_NAME ='中村'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 4297;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='次朗'	,CUST_LAST_NAME ='中村'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 11408;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博司'	,CUST_LAST_NAME ='津村'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 22985;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博己'	,CUST_LAST_NAME ='島田'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 30097;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='智則'	,CUST_LAST_NAME ='島田'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 36322;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='久義'	,CUST_LAST_NAME ='藤木'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 11403;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='隆司'	,CUST_LAST_NAME ='内野'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 10530;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='恭司'	,CUST_LAST_NAME ='龍野'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 23856;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由実'	,CUST_LAST_NAME ='阿川'	,CUST_GENDER ='F'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 42522;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博己'	,CUST_LAST_NAME ='阿部'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 17633;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='隆夫'	,CUST_LAST_NAME ='愛光'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 42526;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='賢治'	,CUST_LAST_NAME ='安西'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 30086;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='香菜'	,CUST_LAST_NAME ='安西'	,CUST_GENDER ='F'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 24745;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='公子'	,CUST_LAST_NAME ='安達'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 10526;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='公子'	,CUST_LAST_NAME ='伊藤'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 17637;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='和彦'	,CUST_LAST_NAME ='伊藤'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 5172;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='悠太'	,CUST_LAST_NAME ='越智'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 36296;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='草子'	,CUST_LAST_NAME ='紀藤'	,CUST_GENDER ='F'	,CUST_CITY ='北九州'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 43407;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美保'	,CUST_LAST_NAME ='吉田'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 4296;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='正路'	,CUST_LAST_NAME ='吉田'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 11407;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勲'	,CUST_LAST_NAME ='鯉沼'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 29220;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='省吾'	,CUST_LAST_NAME ='荒井'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 42553;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='志哲'	,CUST_LAST_NAME ='佐々原'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 37025;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='竜也'	,CUST_LAST_NAME ='佐藤'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 1717;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='幸人'	,CUST_LAST_NAME ='山崎'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 7938;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='亮太'	,CUST_LAST_NAME ='山田'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 45291;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美智子'	,CUST_LAST_NAME ='小松田'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 20403;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美季'	,CUST_LAST_NAME ='照屋'	,CUST_GENDER ='F'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 27514;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='深雪'	,CUST_LAST_NAME ='新田'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 7939;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='淳司'	,CUST_LAST_NAME ='進藤'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 37014;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勇気'	,CUST_LAST_NAME ='杉崎'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 1716;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='俊太'	,CUST_LAST_NAME ='成田'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 44444;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真澄'	,CUST_LAST_NAME ='西山'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 26630;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='義男'	,CUST_LAST_NAME ='石川'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 45295;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='秀樹'	,CUST_LAST_NAME ='川野'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 13297;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='誠司'	,CUST_LAST_NAME ='大崎'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 20407;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='結城'	,CUST_LAST_NAME ='大塚'	,CUST_GENDER ='F'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 26606;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='良子'	,CUST_LAST_NAME ='中口'	,CUST_GENDER ='F'	,CUST_CITY ='北九州'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 33716;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='孝司'	,CUST_LAST_NAME ='中森'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 48222;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='茂'	,CUST_LAST_NAME ='中川'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 32855;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='正子'	,CUST_LAST_NAME ='田口'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 45319;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由香里'	,CUST_LAST_NAME ='田村'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 32859;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='ゆかり'	,CUST_LAST_NAME ='田村'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 31988;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='秀人'	,CUST_LAST_NAME ='田畑'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 45321;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勲'	,CUST_LAST_NAME ='杜'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 2425;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由美'	,CUST_LAST_NAME ='藤田'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 48256;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='和彦'	,CUST_LAST_NAME ='平尾'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 23144;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩'	,CUST_LAST_NAME ='北野'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 44449;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真美'	,CUST_LAST_NAME ='阿川'	,CUST_GENDER ='F'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 39062;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='隆夫'	,CUST_LAST_NAME ='阿部'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 14173;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='孝幸'	,CUST_LAST_NAME ='安部'	,CUST_GENDER ='M'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 21284;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博夫'	,CUST_LAST_NAME ='伊藤'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 50839;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='夏実'	,CUST_LAST_NAME ='松村'	,CUST_GENDER ='F'	,CUST_CITY ='東京'	,CUST_STATE_PROVINCE ='東京'	WHERE CUST_ID = 10584;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='重徳'	,CUST_LAST_NAME ='菅'	,CUST_GENDER ='M'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 14140;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='祐子'	,CUST_LAST_NAME ='村上'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 39097;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='義男'	,CUST_LAST_NAME ='田川'	,CUST_GENDER ='M'	,CUST_CITY ='北九州'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 19724;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='直樹'	,CUST_LAST_NAME ='木内'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 19526;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='泰子'	,CUST_LAST_NAME ='澤藤'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 26638;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='琢哉'	,CUST_LAST_NAME ='阿川'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 26626;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='山信'	,CUST_LAST_NAME ='愛甲'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 32860;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='俊之'	,CUST_LAST_NAME ='安達'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 13298;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='大樹'	,CUST_LAST_NAME ='伊藤'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 26605;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='仁'	,CUST_LAST_NAME ='伊藤'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 14145;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='菜穂子'	,CUST_LAST_NAME ='伊藤'	,CUST_GENDER ='F'	,CUST_CITY ='北九州'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 21256;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='朋美'	,CUST_LAST_NAME ='伊澤'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 31986;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='隆裕'	,CUST_LAST_NAME ='井上'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 19530;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='静江'	,CUST_LAST_NAME ='宇津木'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 13301;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由香里'	,CUST_LAST_NAME ='横田'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 20395;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博己'	,CUST_LAST_NAME ='近森'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 44442;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='浩太'	,CUST_LAST_NAME ='古橋'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 48220;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美季'	,CUST_LAST_NAME ='佐竹'	,CUST_GENDER ='F'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 10868;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='健治'	,CUST_LAST_NAME ='山下'	,CUST_GENDER ='M'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 39975;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美弥子'	,CUST_LAST_NAME ='山田'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 25753;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美那'	,CUST_LAST_NAME ='山田'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 32863;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='公子'	,CUST_LAST_NAME ='松雄'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 31985;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由起子'	,CUST_LAST_NAME ='新場'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 26634;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='芳子'	,CUST_LAST_NAME ='石井'	,CUST_GENDER ='F'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 33744;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='大輔'	,CUST_LAST_NAME ='石原'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 45479;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='さやか'	,CUST_LAST_NAME ='石川'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 20394;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='洋二'	,CUST_LAST_NAME ='浅見'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 38220;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美那'	,CUST_LAST_NAME ='相川'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 7070;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='祐未'	,CUST_LAST_NAME ='相沢'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 45318;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='和'	,CUST_LAST_NAME ='大場'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 19527;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='岳都'	,CUST_LAST_NAME ='大林'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 26631;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='瑞穂'	,CUST_LAST_NAME ='中谷'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 39086;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='亮一'	,CUST_LAST_NAME ='中嶋'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 19522;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='良規'	,CUST_LAST_NAME ='中野'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 22292;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='浩美'	,CUST_LAST_NAME ='堤'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 29403;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='祐太郎'	,CUST_LAST_NAME ='田口'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 3606;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='圭生'	,CUST_LAST_NAME ='藤井'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 28527;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='香里'	,CUST_LAST_NAME ='藤澤'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 16938;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勇気'	,CUST_LAST_NAME ='福島'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 4474;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='恵介'	,CUST_LAST_NAME ='平塚'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 41859;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='結美'	,CUST_LAST_NAME ='木村'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 10716;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='夕美'	,CUST_LAST_NAME ='鈴木'	,CUST_GENDER ='F'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 35606;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由紀'	,CUST_LAST_NAME ='阿部'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 22296;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='圭生'	,CUST_LAST_NAME ='阿部'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 7222;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='信二'	,CUST_LAST_NAME ='阿部'	,CUST_GENDER ='M'	,CUST_CITY ='北九州'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 14333;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美樹'	,CUST_LAST_NAME ='阿部'	,CUST_GENDER ='F'	,CUST_CITY ='東京'	,CUST_STATE_PROVINCE ='東京'	WHERE CUST_ID = 9893;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='隆史'	,CUST_LAST_NAME ='愛甲'	,CUST_GENDER ='M'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 13449;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩'	,CUST_LAST_NAME ='安重'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 11136;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='有三'	,CUST_LAST_NAME ='安西'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 16070;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='慎吾'	,CUST_LAST_NAME ='安西'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 9839;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='健之'	,CUST_LAST_NAME ='安西'	,CUST_GENDER ='M'	,CUST_CITY ='東京'	,CUST_STATE_PROVINCE ='東京'	WHERE CUST_ID = 50893;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='智人'	,CUST_LAST_NAME ='安西'	,CUST_GENDER ='M'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 4450;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由美子'	,CUST_LAST_NAME ='安達'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 16939;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='晴美'	,CUST_LAST_NAME ='安部'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 35631;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='孝司'	,CUST_LAST_NAME ='伊藤'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 4455;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='篤夫'	,CUST_LAST_NAME ='伊藤'	,CUST_GENDER ='M'	,CUST_CITY ='北九州'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 11565;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩'	,CUST_LAST_NAME ='伊藤'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 29394;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='恵一'	,CUST_LAST_NAME ='伊藤'	,CUST_GENDER ='M'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 49133;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='康則'	,CUST_LAST_NAME ='伊藤'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 16911;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='利明'	,CUST_LAST_NAME ='伊藤'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 23171;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩'	,CUST_LAST_NAME ='伊藤'	,CUST_GENDER ='M'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 30283;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='敏弘'	,CUST_LAST_NAME ='宇木'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 41852;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='景子'	,CUST_LAST_NAME ='加藤'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 11191;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='昌美'	,CUST_LAST_NAME ='吉田'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 9838;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='吉春'	,CUST_LAST_NAME ='吉田'	,CUST_GENDER ='M'	,CUST_CITY ='北九州'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 42715;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='信吾'	,CUST_LAST_NAME ='吉田'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 3605;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='裕太'	,CUST_LAST_NAME ='吉田'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 10715;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='佐知子'	,CUST_LAST_NAME ='橋本'	,CUST_GENDER ='F'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 10683;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='康一郎'	,CUST_LAST_NAME ='近藤'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 35626;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='梓'	,CUST_LAST_NAME ='近藤'	,CUST_GENDER ='F'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 36514;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='なつみ'	,CUST_LAST_NAME ='金井'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 28526;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='静香'	,CUST_LAST_NAME ='金子'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 48251;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勇樹'	,CUST_LAST_NAME ='月森'	,CUST_GENDER ='M'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 23139;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩'	,CUST_LAST_NAME ='後藤'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 4479;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='亜由美'	,CUST_LAST_NAME ='高橋'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 35630;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='るり子'	,CUST_LAST_NAME ='高田'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 29395;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='利子'	,CUST_LAST_NAME ='佐藤'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 22297;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='正樹'	,CUST_LAST_NAME ='佐藤'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 28522;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='広美'	,CUST_LAST_NAME ='笹塚'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 35634;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='好子'	,CUST_LAST_NAME ='三室'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 41855;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='省太'	,CUST_LAST_NAME ='山下'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 48244;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='正義'	,CUST_LAST_NAME ='山口'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 44448;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='憲次'	,CUST_LAST_NAME ='山口'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 48226;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='知子'	,CUST_LAST_NAME ='山田'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 16062;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='陽介'	,CUST_LAST_NAME ='鹿野'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 23172;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='佳美'	,CUST_LAST_NAME ='守村'	,CUST_GENDER ='F'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 30284;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='秀樹'	,CUST_LAST_NAME ='守村'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 35605;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='俊一'	,CUST_LAST_NAME ='手塚'	,CUST_GENDER ='M'	,CUST_CITY ='東京'	,CUST_STATE_PROVINCE ='東京'	WHERE CUST_ID = 47431;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='信夫'	,CUST_LAST_NAME ='勝山'	,CUST_GENDER ='M'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 50986;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='義彦'	,CUST_LAST_NAME ='小松田'	,CUST_GENDER ='M'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 38367;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='隆史'	,CUST_LAST_NAME ='小松田'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 50988;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='達也'	,CUST_LAST_NAME ='新場'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 7251;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='達哉'	,CUST_LAST_NAME ='新藤'	,CUST_GENDER ='M'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 14363;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='岳'	,CUST_LAST_NAME ='森'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 38792;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由起子'	,CUST_LAST_NAME ='森本'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 13479;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='伊織'	,CUST_LAST_NAME ='進藤'	,CUST_GENDER ='F'	,CUST_CITY ='東京'	,CUST_STATE_PROVINCE ='東京'	WHERE CUST_ID = 34812;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真澄'	,CUST_LAST_NAME ='西田'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 32140;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博美'	,CUST_LAST_NAME ='石井'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 30147;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由紀子'	,CUST_LAST_NAME ='石井'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 13474;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='敬一'	,CUST_LAST_NAME ='石井'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 44625;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='英二'	,CUST_LAST_NAME ='石川'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 4180;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博幸'	,CUST_LAST_NAME ='石川'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 25062;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='亜衣'	,CUST_LAST_NAME ='石川'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 32173;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩'	,CUST_LAST_NAME ='赤羽'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 40986;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='和彦'	,CUST_LAST_NAME ='赤羽'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 38847;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='洋'	,CUST_LAST_NAME ='赤星'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 7244;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='山信'	,CUST_LAST_NAME ='浅見'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 12605;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='薫'	,CUST_LAST_NAME ='浅見'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 19715;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='仁'	,CUST_LAST_NAME ='浅見'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 41863;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='裕大'	,CUST_LAST_NAME ='浅見'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 34753;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='紀夫'	,CUST_LAST_NAME ='浅野'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 50145;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='節子'	,CUST_LAST_NAME ='前田'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 138;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美樹'	,CUST_LAST_NAME ='相川'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 38914;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美津子'	,CUST_LAST_NAME ='相沢'	,CUST_GENDER ='F'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 19683;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由美子'	,CUST_LAST_NAME ='相澤'	,CUST_GENDER ='F'	,CUST_CITY ='北九州'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 26795;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩'	,CUST_LAST_NAME ='足立'	,CUST_GENDER ='F'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 38613;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='涼太'	,CUST_LAST_NAME ='足立'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 7220;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='吉春'	,CUST_LAST_NAME ='大場'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 41860;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='竜太'	,CUST_LAST_NAME ='谷口'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 40988;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='静江'	,CUST_LAST_NAME ='池田'	,CUST_GENDER ='F'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 13450;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='哲郎'	,CUST_LAST_NAME ='池田'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 30080;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='義教'	,CUST_LAST_NAME ='中村'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 193;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='義弘'	,CUST_LAST_NAME ='中谷'	,CUST_GENDER ='M'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 8133;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='ひろみ'	,CUST_LAST_NAME ='中島'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 25938;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美季'	,CUST_LAST_NAME ='津村'	,CUST_GENDER ='F'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 44604;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美菜'	,CUST_LAST_NAME ='田村'	,CUST_GENDER ='F'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 13455;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='敏弘'	,CUST_LAST_NAME ='田中'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 25911;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='玲子'	,CUST_LAST_NAME ='田中'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 40985;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由起子'	,CUST_LAST_NAME ='田島'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 12606;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='静江'	,CUST_LAST_NAME ='杜'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 25939;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='航'	,CUST_LAST_NAME ='湯浅'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 31296;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='輝久'	,CUST_LAST_NAME ='藤井'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 47555;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='岳朗'	,CUST_LAST_NAME ='藤田'	,CUST_GENDER ='M'	,CUST_CITY ='東京'	,CUST_STATE_PROVINCE ='東京'	WHERE CUST_ID = 30680;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='裕彦'	,CUST_LAST_NAME ='藤田'	,CUST_GENDER ='M'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 47526;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='純一'	,CUST_LAST_NAME ='迫田'	,CUST_GENDER ='M'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 28676;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='利明'	,CUST_LAST_NAME ='迫田'	,CUST_GENDER ='M'	,CUST_CITY ='東京'	,CUST_STATE_PROVINCE ='東京'	WHERE CUST_ID = 6430;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩'	,CUST_LAST_NAME ='富田'	,CUST_GENDER ='M'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 9986;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='環'	,CUST_LAST_NAME ='平岡'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 47559;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='穂波'	,CUST_LAST_NAME ='平岡'	,CUST_GENDER ='F'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 22448;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩'	,CUST_LAST_NAME ='平河'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 34061;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真'	,CUST_LAST_NAME ='堀'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 41161;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='修一'	,CUST_LAST_NAME ='木村'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 18839;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='るり子'	,CUST_LAST_NAME ='野間'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 38394;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由美'	,CUST_LAST_NAME ='野澤'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 4202;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='宏'	,CUST_LAST_NAME ='蓮見'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 41140;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='宏'	,CUST_LAST_NAME ='和田'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 9140;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='知子'	,CUST_LAST_NAME ='龝山'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 16251;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='平治'	,CUST_LAST_NAME ='阿川'	,CUST_GENDER ='M'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 23363;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='玲菜'	,CUST_LAST_NAME ='愛光'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 44630;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='良平'	,CUST_LAST_NAME ='愛甲'	,CUST_GENDER ='M'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 3947;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勇喜'	,CUST_LAST_NAME ='安西'	,CUST_GENDER ='M'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 9987;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='孝子'	,CUST_LAST_NAME ='安達'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 47560;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='康平'	,CUST_LAST_NAME ='安藤'	,CUST_GENDER ='M'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 4672;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='雄二'	,CUST_LAST_NAME ='伊沢'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 22449;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勇斗'	,CUST_LAST_NAME ='伊藤'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 43752;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='正樹'	,CUST_LAST_NAME ='伊澤'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 47530;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='祐子'	,CUST_LAST_NAME ='鵜木'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 45514;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='弘治'	,CUST_LAST_NAME ='園田'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 3788;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真澄'	,CUST_LAST_NAME ='岸本'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 4313;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='崇行'	,CUST_LAST_NAME ='古田'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 16222;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真二'	,CUST_LAST_NAME ='高橋'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 47553;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='雅人'	,CUST_LAST_NAME ='佐々木'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 37526;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='るり子'	,CUST_LAST_NAME ='佐々木'	,CUST_GENDER ='F'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 13091;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='和枝'	,CUST_LAST_NAME ='佐藤'	,CUST_GENDER ='F'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 9989;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='貴子'	,CUST_LAST_NAME ='山口'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 38395;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='慶徳'	,CUST_LAST_NAME ='山崎'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 16244;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真季'	,CUST_LAST_NAME ='若島'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 2918;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='大助'	,CUST_LAST_NAME ='守村'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 3782;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='治雄'	,CUST_LAST_NAME ='小林'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 10017;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='速夫'	,CUST_LAST_NAME ='松田'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 31297;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美菜'	,CUST_LAST_NAME ='森'	,CUST_GENDER ='F'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 47527;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='結美'	,CUST_LAST_NAME ='森本'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 37527;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博'	,CUST_LAST_NAME ='瀬戸'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 46684;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='平治'	,CUST_LAST_NAME ='清水'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 3795;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='未歩'	,CUST_LAST_NAME ='石井'	,CUST_GENDER ='F'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 28683;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='篤夫'	,CUST_LAST_NAME ='石井'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 22473;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='冴子'	,CUST_LAST_NAME ='石原'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 38403;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博美'	,CUST_LAST_NAME ='石川'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 31292;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='瑞貴'	,CUST_LAST_NAME ='石野'	,CUST_GENDER ='M'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 39283;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博英'	,CUST_LAST_NAME ='赤羽'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 25061;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='淳司'	,CUST_LAST_NAME ='赤羽'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 32172;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美菜子'	,CUST_LAST_NAME ='仙道'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 44629;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='伸子'	,CUST_LAST_NAME ='相川'	,CUST_GENDER ='F'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 3936;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩'	,CUST_LAST_NAME ='足立'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 4291;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='健二'	,CUST_LAST_NAME ='足立'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 16220;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='孝子'	,CUST_LAST_NAME ='足立'	,CUST_GENDER ='F'	,CUST_CITY ='東京'	,CUST_STATE_PROVINCE ='東京'	WHERE CUST_ID = 25121;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='良人'	,CUST_LAST_NAME ='中森'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 37522;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='宣雄'	,CUST_LAST_NAME ='中村'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 44633;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='正巳'	,CUST_LAST_NAME ='田村'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 3980;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='喜美雄'	,CUST_LAST_NAME ='田嶋'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 3783;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='大亮'	,CUST_LAST_NAME ='渡辺'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 2911;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='大亮'	,CUST_LAST_NAME ='藤井'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 10022;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='香奈'	,CUST_LAST_NAME ='尾崎'	,CUST_GENDER ='F'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 34911;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='深雪'	,CUST_LAST_NAME ='武石'	,CUST_GENDER ='F'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 50300;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='隆之'	,CUST_LAST_NAME ='平塚'	,CUST_GENDER ='M'	,CUST_CITY ='北九州'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 7411;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='大'	,CUST_LAST_NAME ='北川'	,CUST_GENDER ='M'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 18986;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='隆久'	,CUST_LAST_NAME ='矢田'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 50320;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='典子'	,CUST_LAST_NAME ='鈴木'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 34060;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='啓太'	,CUST_LAST_NAME ='龝山'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 6555;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='啓二'	,CUST_LAST_NAME ='安西'	,CUST_GENDER ='M'	,CUST_CITY ='東京'	,CUST_STATE_PROVINCE ='東京'	WHERE CUST_ID = 27889;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博史'	,CUST_LAST_NAME ='安西'	,CUST_GENDER ='M'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 31444;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='茂子'	,CUST_LAST_NAME ='安部'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 23226;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='大'	,CUST_LAST_NAME ='安部'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 23237;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='祐樹'	,CUST_LAST_NAME ='宇木'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 6530;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='啓祐'	,CUST_LAST_NAME ='岡山'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 28700;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='紀子'	,CUST_LAST_NAME ='海老坂'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 12783;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='孝子'	,CUST_LAST_NAME ='丸山'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 18145;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由美'	,CUST_LAST_NAME ='岩崎'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 37701;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='孝子'	,CUST_LAST_NAME ='吉澤'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 5684;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='香奈'	,CUST_LAST_NAME ='近藤'	,CUST_GENDER ='F'	,CUST_CITY ='東京'	,CUST_STATE_PROVINCE ='東京'	WHERE CUST_ID = 40350;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='仁子'	,CUST_LAST_NAME ='金子'	,CUST_GENDER ='F'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 43905;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='良典'	,CUST_LAST_NAME ='原'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 19017;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='啓之'	,CUST_LAST_NAME ='高岡'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 43910;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='武'	,CUST_LAST_NAME ='坂田'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 11910;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩'	,CUST_LAST_NAME ='三重'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 19022;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='直子'	,CUST_LAST_NAME ='山崎'	,CUST_GENDER ='F'	,CUST_CITY ='北九州'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 13642;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='雄二'	,CUST_LAST_NAME ='手塚'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 23179;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勇斗'	,CUST_LAST_NAME ='深津'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 50331;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勇次'	,CUST_LAST_NAME ='須藤'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 25220;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='隆夫'	,CUST_LAST_NAME ='瀬戸'	,CUST_GENDER ='M'	,CUST_CITY ='北九州'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 32331;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='光輝'	,CUST_LAST_NAME ='清水'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 21605;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='実菜子'	,CUST_LAST_NAME ='清水'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 50322;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='健吾'	,CUST_LAST_NAME ='西田'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 22478;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩'	,CUST_LAST_NAME ='赤羽'	,CUST_GENDER ='F'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 50297;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美由紀'	,CUST_LAST_NAME ='千田'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 40297;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='英二'	,CUST_LAST_NAME ='川鍋'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 50319;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='泰子'	,CUST_LAST_NAME ='泉'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 12782;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='基樹'	,CUST_LAST_NAME ='相川'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 6560;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='寛之'	,CUST_LAST_NAME ='相澤'	,CUST_GENDER ='M'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 13671;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真'	,CUST_LAST_NAME ='相澤'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 31448;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='省太'	,CUST_LAST_NAME ='足立'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 41173;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩'	,CUST_LAST_NAME ='足立'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 9145;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='靖夫'	,CUST_LAST_NAME ='滝川'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 40292;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='希'	,CUST_LAST_NAME ='中田'	,CUST_GENDER ='F'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 31669;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='恵一'	,CUST_LAST_NAME ='田原'	,CUST_GENDER ='M'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 6526;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='隆平'	,CUST_LAST_NAME ='渡辺'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 31957;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='幸弘'	,CUST_LAST_NAME ='島'	,CUST_GENDER ='M'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 1210;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='今日子'	,CUST_LAST_NAME ='内田'	,CUST_GENDER ='F'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 18987;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真澄'	,CUST_LAST_NAME ='波多野'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 23201;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='めぐみ'	,CUST_LAST_NAME ='馬場'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 34939;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='秀人'	,CUST_LAST_NAME ='平河'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 49449;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勇気'	,CUST_LAST_NAME ='龝山'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 6561;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='幸男'	,CUST_LAST_NAME ='安達'	,CUST_GENDER ='M'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 13672;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='幸男'	,CUST_LAST_NAME ='安藤'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 31449;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='照子'	,CUST_LAST_NAME ='安藤'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 6553;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='武志'	,CUST_LAST_NAME ='安部'	,CUST_GENDER ='M'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 50296;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='道徳'	,CUST_LAST_NAME ='臼井'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 40296;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='隆人'	,CUST_LAST_NAME ='吉田'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 6527;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='景子'	,CUST_LAST_NAME ='桑内'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 41172;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美貴'	,CUST_LAST_NAME ='古橋'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 34938;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='香織'	,CUST_LAST_NAME ='今田'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 21604;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='多美子'	,CUST_LAST_NAME ='佐竹'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 31946;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='英敏'	,CUST_LAST_NAME ='佐竹'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 31979;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩'	,CUST_LAST_NAME ='佐藤'	,CUST_GENDER ='F'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 18989;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='友里'	,CUST_LAST_NAME ='佐藤'	,CUST_GENDER ='F'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 3070;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='淳一'	,CUST_LAST_NAME ='坂田'	,CUST_GENDER ='M'	,CUST_CITY ='北九州'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 10181;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='利子'	,CUST_LAST_NAME ='山岸'	,CUST_GENDER ='F'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 15527;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真美子'	,CUST_LAST_NAME ='山崎'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 30605;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='大亮'	,CUST_LAST_NAME ='山田'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 15531;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='大亮'	,CUST_LAST_NAME ='山本'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 47391;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='大亮'	,CUST_LAST_NAME ='寺西'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 9300;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='大亮'	,CUST_LAST_NAME ='柴崎'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 47347;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='正路'	,CUST_LAST_NAME ='秋山'	,CUST_GENDER ='M'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 6158;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='宏樹'	,CUST_LAST_NAME ='所'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 9296;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='宏樹'	,CUST_LAST_NAME ='西脇'	,CUST_GENDER ='M'	,CUST_CITY ='北九州'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 35100;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勝信'	,CUST_LAST_NAME ='青山'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 34238;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='良太'	,CUST_LAST_NAME ='青森'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 28017;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='竜也'	,CUST_LAST_NAME ='石井'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 34243;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由衣'	,CUST_LAST_NAME ='石井'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 2221;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真幸'	,CUST_LAST_NAME ='石井'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 9331;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='雄一郎'	,CUST_LAST_NAME ='石井'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 34219;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='千輔'	,CUST_LAST_NAME ='石野'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 15554;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='亮子'	,CUST_LAST_NAME ='石野'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 19010;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='政美'	,CUST_LAST_NAME ='石野'	,CUST_GENDER ='M'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 37677;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='桂'	,CUST_LAST_NAME ='赤羽'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 12788;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='恵美'	,CUST_LAST_NAME ='仙道'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 46861;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='拓哉'	,CUST_LAST_NAME ='仙道'	,CUST_GENDER ='M'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 47750;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='裕子'	,CUST_LAST_NAME ='相川'	,CUST_GENDER ='F'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 38589;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='恵子'	,CUST_LAST_NAME ='足立'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 31478;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='理麻'	,CUST_LAST_NAME ='大塚'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 31473;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='俊'	,CUST_LAST_NAME ='池田'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 15528;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='宗一'	,CUST_LAST_NAME ='中森'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 47358;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='多嘉子'	,CUST_LAST_NAME ='長谷川'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 47269;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='良知'	,CUST_LAST_NAME ='渡辺'	,CUST_GENDER ='M'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 6169;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='直樹'	,CUST_LAST_NAME ='藤村'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 43061;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='義則'	,CUST_LAST_NAME ='八代'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 46840;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='学'	,CUST_LAST_NAME ='富田'	,CUST_GENDER ='M'	,CUST_CITY ='北九州'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 3951;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='智成'	,CUST_LAST_NAME ='武岡'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 46860;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='久'	,CUST_LAST_NAME ='武藤'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 47280;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='恵理'	,CUST_LAST_NAME ='伏見'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 47313;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='恵子'	,CUST_LAST_NAME ='本郷'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 30604;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='俊太郎'	,CUST_LAST_NAME ='木ノ内'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 43937;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩'	,CUST_LAST_NAME ='愛川'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 46864;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='芳正'	,CUST_LAST_NAME ='安部'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 25244;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='武志'	,CUST_LAST_NAME ='伊藤'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 49454;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='実菜子'	,CUST_LAST_NAME ='伊藤'	,CUST_GENDER ='F'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 47014;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='奈美'	,CUST_LAST_NAME ='伊藤'	,CUST_GENDER ='F'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 47749;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='行夫'	,CUST_LAST_NAME ='井上'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 18140;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='信広'	,CUST_LAST_NAME ='岐阜'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 25251;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='千代'	,CUST_LAST_NAME ='境'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 43938;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='信広'	,CUST_LAST_NAME ='戸川'	,CUST_GENDER ='M'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 47025;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='義徳'	,CUST_LAST_NAME ='鯉沼'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 9297;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='雅人'	,CUST_LAST_NAME ='江尻'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 43060;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='良平'	,CUST_LAST_NAME ='高田'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 46839;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美那'	,CUST_LAST_NAME ='佐藤'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 27140;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美那'	,CUST_LAST_NAME ='秋葉'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 34250;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='浩一'	,CUST_LAST_NAME ='須藤'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 39604;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='弘樹'	,CUST_LAST_NAME ='石井'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 3097;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='憲一'	,CUST_LAST_NAME ='川久保'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 2227;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩'	,CUST_LAST_NAME ='川鍋'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 5840;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勇気'	,CUST_LAST_NAME ='大崎'	,CUST_GENDER ='M'	,CUST_CITY ='東京'	,CUST_STATE_PROVINCE ='東京'	WHERE CUST_ID = 27197;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='義則'	,CUST_LAST_NAME ='大坪'	,CUST_GENDER ='M'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 30752;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='明貴'	,CUST_LAST_NAME ='丹下'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 48763;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='信雄'	,CUST_LAST_NAME ='田村'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 4987;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='篤志'	,CUST_LAST_NAME ='浜田'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 12097;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美菜子'	,CUST_LAST_NAME ='野澤'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 49633;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='春都'	,CUST_LAST_NAME ='鈴木'	,CUST_GENDER ='M'	,CUST_CITY ='東京'	,CUST_STATE_PROVINCE ='東京'	WHERE CUST_ID = 20966;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='和弘'	,CUST_LAST_NAME ='澤藤'	,CUST_GENDER ='M'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 24523;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='弘樹'	,CUST_LAST_NAME ='龝山'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 16236;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='薫'	,CUST_LAST_NAME ='阿部'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 49637;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='和弘'	,CUST_LAST_NAME ='阿部'	,CUST_GENDER ='M'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 6749;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='正子'	,CUST_LAST_NAME ='阿部'	,CUST_GENDER ='F'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 24527;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='浩子'	,CUST_LAST_NAME ='阿部'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 21782;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美穂子'	,CUST_LAST_NAME ='安西'	,CUST_GENDER ='F'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 40448;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='良一'	,CUST_LAST_NAME ='安達'	,CUST_GENDER ='M'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 10208;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='雅人'	,CUST_LAST_NAME ='安達'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 27986;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='弘治'	,CUST_LAST_NAME ='安達'	,CUST_GENDER ='M'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 49604;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='玲菜'	,CUST_LAST_NAME ='安藤'	,CUST_GENDER ='F'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 49605;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='まどか'	,CUST_LAST_NAME ='安藤'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 28010;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='大亮'	,CUST_LAST_NAME ='伊集院'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 9322;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩'	,CUST_LAST_NAME ='伊東'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 20910;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='拓也'	,CUST_LAST_NAME ='伊藤'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 28022;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='まどか'	,CUST_LAST_NAME ='伊藤'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 21777;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美保'	,CUST_LAST_NAME ='奥村'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 21787;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='芳江'	,CUST_LAST_NAME ='横沢'	,CUST_GENDER ='F'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 28899;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='信治'	,CUST_LAST_NAME ='亀貝'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 14684;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='吉春'	,CUST_LAST_NAME ='吉田'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 40473;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='辰也'	,CUST_LAST_NAME ='吉田'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 9319;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='裕子'	,CUST_LAST_NAME ='吉田'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 9320;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='省吾'	,CUST_LAST_NAME ='吉田'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 45987;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='義啓'	,CUST_LAST_NAME ='近藤'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 3098;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勇樹'	,CUST_LAST_NAME ='見学'	,CUST_GENDER ='M'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 10209;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='紀之'	,CUST_LAST_NAME ='高岡'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 27987;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='大助'	,CUST_LAST_NAME ='佐々原'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 45989;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='鉄也'	,CUST_LAST_NAME ='佐々木'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 3100;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='雅音'	,CUST_LAST_NAME ='斎藤'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 8448;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美那'	,CUST_LAST_NAME ='細田'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 15560;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='みのり'	,CUST_LAST_NAME ='三重'	,CUST_GENDER ='F'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 22670;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='正直'	,CUST_LAST_NAME ='山岸'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 21781;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='芳正'	,CUST_LAST_NAME ='山口'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 40449;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='敦子'	,CUST_LAST_NAME ='篠原'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 8449;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='芳正'	,CUST_LAST_NAME ='小松田'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 15561;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='敏也'	,CUST_LAST_NAME ='松井'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 27989;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='俊雄'	,CUST_LAST_NAME ='新井'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 39605;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='恭司'	,CUST_LAST_NAME ='進藤'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 27145;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='聡史'	,CUST_LAST_NAME ='須藤'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 40478;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美由紀'	,CUST_LAST_NAME ='須藤'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 33367;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='久美子'	,CUST_LAST_NAME ='青山'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 8454;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='みのり'	,CUST_LAST_NAME ='青山'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 2223;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美里'	,CUST_LAST_NAME ='青木'	,CUST_GENDER ='F'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 40444;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美季'	,CUST_LAST_NAME ='石川'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 15556;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美菜子'	,CUST_LAST_NAME ='石川'	,CUST_GENDER ='F'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 5839;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='亜由美'	,CUST_LAST_NAME ='石川'	,CUST_GENDER ='F'	,CUST_CITY ='北九州'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 12950;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='智亜子'	,CUST_LAST_NAME ='石野'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 49629;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='裕子'	,CUST_LAST_NAME ='石野'	,CUST_GENDER ='F'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 1065;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='省吾'	,CUST_LAST_NAME ='千田'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 4989;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='正樹'	,CUST_LAST_NAME ='川鍋'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 12099;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='秀人'	,CUST_LAST_NAME ='川野'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 12069;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='智人'	,CUST_LAST_NAME ='浅見'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 30777;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='篤子'	,CUST_LAST_NAME ='浅見'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 11222;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='優大'	,CUST_LAST_NAME ='浅野'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 31;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='利子'	,CUST_LAST_NAME ='相場'	,CUST_GENDER ='F'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 24528;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勝久'	,CUST_LAST_NAME ='相川'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 24556;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='康平'	,CUST_LAST_NAME ='相川'	,CUST_GENDER ='M'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 31666;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='宏'	,CUST_LAST_NAME ='相川'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 253;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='薫'	,CUST_LAST_NAME ='相川'	,CUST_GENDER ='F'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 1018;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美樹'	,CUST_LAST_NAME ='村上'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 49630;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='孝之'	,CUST_LAST_NAME ='大場'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 36987;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='秀人'	,CUST_LAST_NAME ='沢藤'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 24554;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='秀樹'	,CUST_LAST_NAME ='池田'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 394;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='恵子'	,CUST_LAST_NAME ='池田'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 101624;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美菜子'	,CUST_LAST_NAME ='池田'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 102351;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='まどか'	,CUST_LAST_NAME ='中川'	,CUST_GENDER ='F'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 100579;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='宅磨'	,CUST_LAST_NAME ='津村'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 103585;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='頼次'	,CUST_LAST_NAME ='佃'	,CUST_GENDER ='M'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 103505;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='茂子'	,CUST_LAST_NAME ='田中'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 100771;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真季'	,CUST_LAST_NAME ='田中'	,CUST_GENDER ='F'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 311;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='今日子'	,CUST_LAST_NAME ='田中'	,CUST_GENDER ='F'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 1093;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='重敏'	,CUST_LAST_NAME ='田中'	,CUST_GENDER ='M'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 865;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='重敏'	,CUST_LAST_NAME ='湯浅'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 756;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='弘樹'	,CUST_LAST_NAME ='八田'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 278;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='良成'	,CUST_LAST_NAME ='平岡'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 25047;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='敦子'	,CUST_LAST_NAME ='平岡'	,CUST_GENDER ='F'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 50518;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勝信'	,CUST_LAST_NAME ='北川'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 18296;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='靖夫'	,CUST_LAST_NAME ='箕浦'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 18320;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='剛史'	,CUST_LAST_NAME ='木下'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 530;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='清次'	,CUST_LAST_NAME ='野澤'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 925;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='晴美'	,CUST_LAST_NAME ='鈴木'	,CUST_GENDER ='F'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 11220;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真澄'	,CUST_LAST_NAME ='鈴木'	,CUST_GENDER ='F'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 143;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='尚美'	,CUST_LAST_NAME ='龝山'	,CUST_GENDER ='F'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 481;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='正人'	,CUST_LAST_NAME ='阿部'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 803;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='雅之'	,CUST_LAST_NAME ='愛川'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 25003;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='順子'	,CUST_LAST_NAME ='伊藤'	,CUST_GENDER ='F'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 1035;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='亮子'	,CUST_LAST_NAME ='伊藤'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 5860;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='久美子'	,CUST_LAST_NAME ='井上'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 25058;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩'	,CUST_LAST_NAME ='河内'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 18319;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真澄'	,CUST_LAST_NAME ='丸山'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 36986;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美奈'	,CUST_LAST_NAME ='岸本'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 5861;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='敬男'	,CUST_LAST_NAME ='吉田'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 16247;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='雅史'	,CUST_LAST_NAME ='吉田'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 49638;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='智弘'	,CUST_LAST_NAME ='吉田'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 18297;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='達哉'	,CUST_LAST_NAME ='吉田'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 16280;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博'	,CUST_LAST_NAME ='橋本'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 5864;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='隆之'	,CUST_LAST_NAME ='戸田'	,CUST_GENDER ='M'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 403;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='洋二'	,CUST_LAST_NAME ='佐竹'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 88;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='誉之'	,CUST_LAST_NAME ='三露'	,CUST_GENDER ='M'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 425;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='智慧次'	,CUST_LAST_NAME ='篠原'	,CUST_GENDER ='M'	,CUST_CITY ='名古屋'	,CUST_STATE_PROVINCE ='愛知'	WHERE CUST_ID = 4986;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='淳一'	,CUST_LAST_NAME ='篠塚'	,CUST_GENDER ='M'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 12096;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='敬之'	,CUST_LAST_NAME ='秋山'	,CUST_GENDER ='M'	,CUST_CITY ='福岡'	,CUST_STATE_PROVINCE ='福岡'	WHERE CUST_ID = 19208;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='ゆり子'	,CUST_LAST_NAME ='小杉'	,CUST_GENDER ='F'	,CUST_CITY ='横浜'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 18322;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勇樹'	,CUST_LAST_NAME ='石野'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 36989;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='健司'	,CUST_LAST_NAME ='赤星'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 197;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='浩子'	,CUST_LAST_NAME ='折田'	,CUST_GENDER ='F'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 168;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勝次'	,CUST_LAST_NAME ='相川'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 614;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='雅音'	,CUST_LAST_NAME ='相川'	,CUST_GENDER ='M'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 410;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博隆'	,CUST_LAST_NAME ='相沢'	,CUST_GENDER ='M'	,CUST_CITY ='京都'	,CUST_STATE_PROVINCE ='京都'	WHERE CUST_ID = 978;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='恭子'	,CUST_LAST_NAME ='足立'	,CUST_GENDER ='F'	,CUST_CITY ='川崎'	,CUST_STATE_PROVINCE ='神奈川'	WHERE CUST_ID = 684;

UPDATE SHJP.CUSTOMERS SET CUST_MARITAL_STATUS = '既婚' WHERE CUST_MARITAL_STATUS = 'married';
UPDATE SHJP.CUSTOMERS SET CUST_MARITAL_STATUS = '独身' WHERE CUST_MARITAL_STATUS = 'single';
UPDATE SHJP.CUSTOMERS SET CUST_TOTAL = '全顧客';

COMMIT;

-- *************************************************
--   COUNTIRES
-- *************************************************

INSERT INTO SHJP.COUNTRIES SELECT * FROM SH.COUNTRIES;

COMMIT;

-- *************************************************
--   PRODUCTS
-- *************************************************

INSERT INTO SHJP.PRODUCTS SELECT * FROM SH.PRODUCTS;

UPDATE SHJP.PRODUCTS SET PROD_NAME = '5メガ・ピクセル デジタルカメラ', PROD_DESC = '5メガ・ピクセル デジタルカメラ' WHERE PROD_ID = 13;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'TVチューナー付き17インチ液晶ディスプレイ', PROD_DESC = 'TVチューナー付き17インチ液晶ディスプレイ' WHERE PROD_ID = 14;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'Envoy 256MB - 40GB', PROD_DESC = 'Envoy 256MB - 40GB' WHERE PROD_ID = 15;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'Y Box', PROD_DESC = 'Y Box' WHERE PROD_ID = 16;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '3.5インチ デジタルビデオ・レコーダー', PROD_DESC = '3.5インチ デジタルビデオ・レコーダー' WHERE PROD_ID = 17;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'Envoy Ambassador', PROD_DESC = 'Envoy Ambassador' WHERE PROD_ID = 18;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'ノートPCキャリーケース', PROD_DESC = 'ノートPCキャリーケース' WHERE PROD_ID = 19;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'DVD AVプレイヤー ホームシアター・パッケージ', PROD_DESC = 'DVD AVプレイヤー ホームシアター・パッケージ' WHERE PROD_ID = 20;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '18インチ フラットパネル・モニタ', PROD_DESC = '18インチ フラットパネル・モニタ' WHERE PROD_ID = 21;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '外付けキーボード', PROD_DESC = '外付けキーボード' WHERE PROD_ID = 22;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '外付け106キーボード', PROD_DESC = '外付け106キーボード' WHERE PROD_ID = 23;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'PCMCIA データ通信カード', PROD_DESC = 'PCMCIA データ通信カード' WHERE PROD_ID = 24;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '128MB USB メモリ', PROD_DESC = '128MB USB メモリ' WHERE PROD_ID = 25;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '256MB USB メモリ', PROD_DESC = '256MB USB メモリ' WHERE PROD_ID = 26;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'マルチメディア・スピーカー', PROD_DESC = 'マルチメディア・スピーカー' WHERE PROD_ID = 27;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'Unix/Windows 1ユーザー・パック', PROD_DESC = 'Unix/Windows 1ユーザー・パック' WHERE PROD_ID = 28;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '5.2ch サラウンド・スピーカー・システム', PROD_DESC = '5.2ch サラウンド・スピーカー・システム' WHERE PROD_ID = 29;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'マウス・パッド', PROD_DESC = 'マウス・パッド' WHERE PROD_ID = 30;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '外付けDVDディスク・ドライブ', PROD_DESC = '外付けDVDディスク・ドライブ' WHERE PROD_ID = 31;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'マルチメディア・スピーカー 5コーン', PROD_DESC = 'マルチメディア・スピーカー 5コーン' WHERE PROD_ID = 32;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'USB データ通信カード', PROD_DESC = 'USB データ通信カード' WHERE PROD_ID = 33;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '外付け6倍速CD-ROMドライブ', PROD_DESC = '外付け6倍速CD-ROMドライブ' WHERE PROD_ID = 34;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '外付け8倍速CD-ROMドライブ', PROD_DESC = '外付け8倍速CD-ROMドライブ' WHERE PROD_ID = 35;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '携帯用外付け6倍速CD-ROMドライブ', PROD_DESC = '携帯用外付け6倍速CD-ROMドライブ' WHERE PROD_ID = 36;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '携帯用外付け8倍速CD-ROMドライブ', PROD_DESC = '携帯用外付け8倍速CD-ROMドライブ' WHERE PROD_ID = 37;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '内蔵6倍速CD-ROMドライブ', PROD_DESC = '内蔵6倍速CD-ROMドライブ' WHERE PROD_ID = 38;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '内蔵8倍速CD-ROMドライブ', PROD_DESC = '内蔵8倍速CD-ROMドライブ' WHERE PROD_ID = 39;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'OS英語マニュアル', PROD_DESC = 'OS英語マニュアル' WHERE PROD_ID = 40;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'OSドイツ語マニュアル', PROD_DESC = 'OSドイツ語マニュアル' WHERE PROD_ID = 41;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'OSフランス語マニュアル', PROD_DESC = 'OSフランス語マニュアル' WHERE PROD_ID = 42;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'OSスペイン語マニュアル', PROD_DESC = 'OSスペイン語マニュアル' WHERE PROD_ID = 43;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'OSイタリア語マニュアル', PROD_DESC = 'OSイタリア語マニュアル' WHERE PROD_ID = 44;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'OS日本語マニュアル', PROD_DESC = 'OS日本語マニュアル' WHERE PROD_ID = 45;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '標準マウス', PROD_DESC = '標準マウス' WHERE PROD_ID = 46;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '光学式マウス', PROD_DESC = '光学式マウス' WHERE PROD_ID = 47;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'キーボード・レスト', PROD_DESC = 'キーボード・レスト' WHERE PROD_ID = 48;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'CD-Rディスク（ケース付き）', PROD_DESC = 'CD-Rディスク（ケース付き）5枚パック' WHERE PROD_ID = 113;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '音楽用CD-R', PROD_DESC = '音楽用CD-R30枚パック' WHERE PROD_ID = 114;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'CD-RW', PROD_DESC = '倍速対応CD-RW 10枚パック' WHERE PROD_ID = 115;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'CD-RW', PROD_DESC = '倍速対応CD-RW 5枚パック' WHERE PROD_ID = 116;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'CD-R', PROD_DESC = '高品質CD-R 5枚パック' WHERE PROD_ID = 117;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '音楽用CD-R', PROD_DESC = '音楽用CD-R10枚パック' WHERE PROD_ID = 118;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'CD-Rディスク（ケース付き）', PROD_DESC = 'CD-Rディスク（ケース付き）12枚パック' WHERE PROD_ID = 119;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'CD-Rディスク（ケース付き）', PROD_DESC = 'CD-Rディスク（ケース付き）片面一層' WHERE PROD_ID = 120;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'DVD-RAMディスク（ケース付き）', PROD_DESC = 'DVD-RAMディスク（ケース付き）片面二層' WHERE PROD_ID = 121;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'DVD-Rディスク', PROD_DESC = 'DVD-Rディスク5枚パック' WHERE PROD_ID = 122;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'DVD-Rディスク', PROD_DESC = 'DVD-Rディスク5枚パック（高品質）' WHERE PROD_ID = 123;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'DVD-RWディスク', PROD_DESC = 'DVD-RWディスク3枚パック' WHERE PROD_ID = 124;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'CDケース50枚収納ボックス', PROD_DESC = 'CDケース50枚収納ボックス' WHERE PROD_ID = 125;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'CDケース100枚収納ボックス', PROD_DESC = 'CDケース100枚収納ボックス' WHERE PROD_ID = 126;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'モデル CD13272 インク・カートリッジ（３色）', PROD_DESC = 'モデル CD13272 インク・カートリッジ（３色）' WHERE PROD_ID = 127;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'モデル SM26273 インク・カートリッジ（黒）', PROD_DESC = 'モデル SM26273 インク・カートリッジ（黒）' WHERE PROD_ID = 128;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'モデル NM500X インク・カートリッジ（黄）', PROD_DESC = 'モデル NM500X インク・カートリッジ（黄）' WHERE PROD_ID = 129;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'モデル A3827H インク・カートリッジ（青）', PROD_DESC = 'モデル A3827H インク・カートリッジ（青）' WHERE PROD_ID = 130;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'モデル K3822L 携帯電話バッテリ', PROD_DESC = 'モデル K3822L 携帯電話バッテリ' WHERE PROD_ID = 131;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'モデル C9827B 携帯電話バッテリ', PROD_DESC = 'モデル C9827B 携帯電話バッテリ' WHERE PROD_ID = 132;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'モデル K8822S 携帯電話バッテリ', PROD_DESC = 'モデル K8822S 携帯電話バッテリ' WHERE PROD_ID = 133;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'モデル C93822D 携帯電話バッテリ', PROD_DESC = 'モデル C93822D 携帯電話バッテリ' WHERE PROD_ID = 134;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'S27273M 緊急用携帯電話バッテリ', PROD_DESC = 'S27274M 緊急用携帯電話バッテリ' WHERE PROD_ID = 135;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '64MB SDメモリ・カード', PROD_DESC = '64MB SDメモリ・カード' WHERE PROD_ID = 136;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '128MB SDメモリ・カード', PROD_DESC = '128MB SDメモリ・カード' WHERE PROD_ID = 137;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '256MB SDメモリ・カード', PROD_DESC = '256MB SDメモリ・カード' WHERE PROD_ID = 138;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '無線LAN中継ステーション', PROD_DESC = '無線LAN中継ステーション' WHERE PROD_ID = 139;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '8時間耐久レース・ゲーム', PROD_DESC = '9時間耐久レース・ゲーム' WHERE PROD_ID = 140;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'スマッシュ・ボクシング', PROD_DESC = 'スマッシュ・ボクシング' WHERE PROD_ID = 141;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'マーシャル・アーツ・チャンピオン', PROD_DESC = 'マーシャル・アーツ・チャンピオン' WHERE PROD_ID = 142;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'アメコミ・ヒーローズ', PROD_DESC = 'アメコミ・ヒーローズ' WHERE PROD_ID = 143;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'フライ・フィッシング', PROD_DESC = 'フライ・フィッシング' WHERE PROD_ID = 144;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'コイン探し', PROD_DESC = 'コイン探し' WHERE PROD_ID = 145;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'ナンバー・アドベンチャー', PROD_DESC = 'ナンバー・アドベンチャー' WHERE PROD_ID = 146;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '追加ケーブル', PROD_DESC = '追加ケーブル' WHERE PROD_ID = 147;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '追加メモリ', PROD_DESC = '追加メモリ' WHERE PROD_ID = 148;

UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'ゲーム機' WHERE PROD_SUBCATEGORY = 'Game Consoles';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = '家庭用オーディオ' WHERE PROD_SUBCATEGORY = 'Home Audio';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'Y Box アクセサリ' WHERE PROD_SUBCATEGORY = 'Y Box Accessories';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'Y Box ゲーム' WHERE PROD_SUBCATEGORY = 'Y Box Games';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'デスクトップPC' WHERE PROD_SUBCATEGORY = 'Desktop PCs';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'ノートPC' WHERE PROD_SUBCATEGORY = 'Portable PCs';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'アクセサリ' WHERE PROD_SUBCATEGORY = 'Accessories';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'CD-ROM' WHERE PROD_SUBCATEGORY = 'CD-ROM';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'メモリ' WHERE PROD_SUBCATEGORY = 'Memory';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'モデム/FAX' WHERE PROD_SUBCATEGORY = 'Modems/Fax';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'モニタ' WHERE PROD_SUBCATEGORY = 'Monitors';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'プリンタ・サプライ' WHERE PROD_SUBCATEGORY = 'Printer Supplies';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'ビデオカメラ' WHERE PROD_SUBCATEGORY = 'Camcorders';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'カメラ・バッテリ' WHERE PROD_SUBCATEGORY = 'Camera Batteries';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'カメラ・メディア' WHERE PROD_SUBCATEGORY = 'Camera Media';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'カメラ' WHERE PROD_SUBCATEGORY = 'Cameras';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'アクセサリ' WHERE PROD_SUBCATEGORY = 'Accessories';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'OS' WHERE PROD_SUBCATEGORY = 'Operating Systems';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'バルク・ディスク' WHERE PROD_SUBCATEGORY = 'Bulk Pack Diskettes';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'マニュアル' WHERE PROD_SUBCATEGORY = 'Documentation';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'CD-R' WHERE PROD_SUBCATEGORY = 'Recordable CDs';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'DVD-R' WHERE PROD_SUBCATEGORY = 'Recordable DVD Discs';

UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'ゲーム機' WHERE PROD_SUBCATEGORY = 'Game Consoles';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = '家庭用オーディオ' WHERE PROD_SUBCATEGORY = 'Home Audio';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'Y Box アクセサリ' WHERE PROD_SUBCATEGORY = 'Y Box Accessories';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'Y Box ゲーム' WHERE PROD_SUBCATEGORY = 'Y Box Games';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'デスクトップPC' WHERE PROD_SUBCATEGORY = 'Desktop PCs';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'ノートPC' WHERE PROD_SUBCATEGORY = 'Portable PCs';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'アクセサリ' WHERE PROD_SUBCATEGORY = 'Accessories';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'CD-ROM' WHERE PROD_SUBCATEGORY = 'CD-ROM';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'メモリ' WHERE PROD_SUBCATEGORY = 'Memory';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'モデム/FAX' WHERE PROD_SUBCATEGORY = 'Modems/Fax';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'モニタ' WHERE PROD_SUBCATEGORY = 'Monitors';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'プリンタ・サプライ' WHERE PROD_SUBCATEGORY = 'Printer Supplies';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'ビデオカメラ' WHERE PROD_SUBCATEGORY = 'Camcorders';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'カメラ・バッテリ' WHERE PROD_SUBCATEGORY = 'Camera Batteries';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'カメラ・メディア' WHERE PROD_SUBCATEGORY = 'Camera Media';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'カメラ' WHERE PROD_SUBCATEGORY = 'Cameras';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'アクセサリ' WHERE PROD_SUBCATEGORY = 'Accessories';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'OS' WHERE PROD_SUBCATEGORY = 'Operating Systems';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'バルク・ディスク' WHERE PROD_SUBCATEGORY = 'Bulk Pack Diskettes';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'マニュアル' WHERE PROD_SUBCATEGORY = 'Documentation';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'CD-R' WHERE PROD_SUBCATEGORY = 'Recordable CDs';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'DVD-R' WHERE PROD_SUBCATEGORY = 'Recordable DVD Discs';

UPDATE SHJP.PRODUCTS SET PROD_CATEGORY_DESC = '家電' WHERE PROD_CATEGORY = 'Electronics';
UPDATE SHJP.PRODUCTS SET PROD_CATEGORY_DESC = 'ハードウェア' WHERE PROD_CATEGORY = 'Hardware';
UPDATE SHJP.PRODUCTS SET PROD_CATEGORY_DESC = '周辺機器・アクセサリ' WHERE PROD_CATEGORY = 'Peripherals and Accessories';
UPDATE SHJP.PRODUCTS SET PROD_CATEGORY_DESC = '写真' WHERE PROD_CATEGORY = 'Photo';
UPDATE SHJP.PRODUCTS SET PROD_CATEGORY_DESC = 'ソフトウェア・その他' WHERE PROD_CATEGORY = 'Software/Other';

UPDATE SHJP.PRODUCTS SET PROD_CATEGORY = '家電' WHERE PROD_CATEGORY = 'Electronics';
UPDATE SHJP.PRODUCTS SET PROD_CATEGORY = 'ハードウェア' WHERE PROD_CATEGORY = 'Hardware';
UPDATE SHJP.PRODUCTS SET PROD_CATEGORY = '周辺機器・アクセサリ' WHERE PROD_CATEGORY = 'Peripherals and Accessories';
UPDATE SHJP.PRODUCTS SET PROD_CATEGORY = '写真' WHERE PROD_CATEGORY = 'Photo';
UPDATE SHJP.PRODUCTS SET PROD_CATEGORY = 'ソフトウェア・その他' WHERE PROD_CATEGORY = 'Software/Other';

UPDATE SHJP.PRODUCTS SET PROD_TOTAL = '全製品';

COMMIT;


-- *************************************************
--   PROMOTIONS
-- *************************************************

INSERT INTO SHJP.PROMOTIONS SELECT * FROM SH.PROMOTIONS;

ALTER TABLE SHJP.PROMOTIONS MODIFY (
 PROMO_NAME  VARCHAR2(40),
 PROMO_TOTAL VARCHAR2(30),
 PROMO_SUBCATEGORY VARCHAR2(40)
);

set serveroutput on size 2000
declare
  p1 number;
  p2 varchar2(30);
  p3 varchar2(30);
 cursor cu is 
   select promo_id p1,
           regexp_replace(promo_name, ' *#.*', '') p2,
           regexp_substr(promo_name, '#.*') p3
      from shjp.promotions;
 cu_rec cu%rowtype;
begin
 open cu;
 loop 
 EXIT WHEN cu%NOTFOUND;
 FETCH cu into cu_rec;
    p1:=cu_rec.p1;
    p2:=cu_rec.p2;
    p3:=cu_rec.p3;
   
    /** begin loop **/
      if p2 = 'NO PROMOTION' then
        update shjp.promotions set promo_name = 'プロモーションなし '||p3 where promo_id = p1;
      elsif p2 = 'TV promotion' then
        update shjp.promotions set promo_name = 'TVプロモーション '||p3 where promo_id = p1;
      elsif p2 = 'blowout sale' then
        update shjp.promotions set promo_name = '大安売り '||p3 where promo_id = p1;
      elsif p2 = 'everyday low price' then
        update shjp.promotions set promo_name = 'エブリィディ・ロープライス '||p3 where promo_id = p1;
      elsif p2 = 'flyer promotion' then
        update shjp.promotions set promo_name = 'ちらし '||p3 where promo_id = p1;
      elsif p2 = 'internet promotion' then
        update shjp.promotions set promo_name = 'インターネット '||p3 where promo_id = p1;
      elsif p2 = 'magazine promotion' then
        update shjp.promotions set promo_name = '雑誌 '||p3 where promo_id = p1;
      elsif p2 = 'newspaper promotion' then
        update shjp.promotions set promo_name = '新聞 '||p3 where promo_id = p1;
      elsif p2 = 'post promotion' then
        update shjp.promotions set promo_name = '郵便 '||p3 where promo_id = p1;
      elsif p2 = 'radio promotion' then
        update shjp.promotions set promo_name = 'ラジオ '||p3 where promo_id = p1;
      else
        dbms_output.put_line ('PROMO_ID:='||p1||p2||p3||'ERROR!!');
      end if;
    /** end loop **/
  end loop;
end;
/

UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = 'プロモーションなし' WHERE PROMO_SUBCATEGORY = 'NO RPOMOTION';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = 'TVコマーシャル' WHERE PROMO_SUBCATEGORY = 'TV commercial';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = 'TV番組スポンサー' WHERE PROMO_SUBCATEGORY = 'TV program sponsorship';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = '広告' WHERE PROMO_SUBCATEGORY = 'ad';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = '雑誌広告' WHERE PROMO_SUBCATEGORY = 'ad magazine';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = '新聞広告' WHERE PROMO_SUBCATEGORY = 'ad news';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = '看板' WHERE PROMO_SUBCATEGORY = 'billboard';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = '雑誌クーポン' WHERE PROMO_SUBCATEGORY = 'coupon magazine';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = '新聞クーポン' WHERE PROMO_SUBCATEGORY = 'coupon news';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = 'ダウンタウンの看板' WHERE PROMO_SUBCATEGORY = 'downtown billboard';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = '高速道路看板' WHERE PROMO_SUBCATEGORY = 'freeway billboard';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = 'ちらし' WHERE PROMO_SUBCATEGORY = 'general flyer';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = '病院のちらし' WHERE PROMO_SUBCATEGORY = 'hospital flyer';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = '家庭向けちらし' WHERE PROMO_SUBCATEGORY = 'household flyer';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = '特別顧客向け割引' WHERE PROMO_SUBCATEGORY = 'loyal customer discount';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = '工場労働者向け雑誌' WHERE PROMO_SUBCATEGORY = 'manufacture rebate magazine';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = '工場労働者向け新聞' WHERE PROMO_SUBCATEGORY = 'manufacture rebate news';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = '新聞' WHERE PROMO_SUBCATEGORY = 'newspaper';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = 'オンライン割引' WHERE PROMO_SUBCATEGORY = 'online discount';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = 'プロモーション・ムービー' WHERE PROMO_SUBCATEGORY = 'promotion movie';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = 'ラジオ・コマーシャル' WHERE PROMO_SUBCATEGORY = 'radio commercial';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = 'ラジオ番組スポンサー' WHERE PROMO_SUBCATEGORY = 'radio program sponsorship';

UPDATE SHJP.PROMOTIONS SET PROMO_CATEGORY = 'プロモーションなし' WHERE PROMO_CATEGORY = 'NO PROMOTION';
UPDATE SHJP.PROMOTIONS SET PROMO_CATEGORY = 'TV' WHERE PROMO_CATEGORY = 'TV';
UPDATE SHJP.PROMOTIONS SET PROMO_CATEGORY = '広告新聞' WHERE PROMO_CATEGORY = 'ad news';
UPDATE SHJP.PROMOTIONS SET PROMO_CATEGORY = 'ちらし' WHERE PROMO_CATEGORY = 'flyer';
UPDATE SHJP.PROMOTIONS SET PROMO_CATEGORY = 'インターネット' WHERE PROMO_CATEGORY = 'internet';
UPDATE SHJP.PROMOTIONS SET PROMO_CATEGORY = '雑誌' WHERE PROMO_CATEGORY = 'magazine';
UPDATE SHJP.PROMOTIONS SET PROMO_CATEGORY = '新聞' WHERE PROMO_CATEGORY = 'newspaper';
UPDATE SHJP.PROMOTIONS SET PROMO_CATEGORY = '郵便' WHERE PROMO_CATEGORY = 'post';
UPDATE SHJP.PROMOTIONS SET PROMO_CATEGORY = 'ラジオ' WHERE PROMO_CATEGORY = 'radio';

UPDATE SHJP.PROMOTIONS SET PROMO_TOTAL = '全プロモーション';

COMMIT;


-- *************************************************
--   TIMES
-- *************************************************

INSERT INTO SHJP.TIMES SELECT * FROM SH.TIMES;

UPDATE SHJP.TIMES SET DAY_NAME = '月曜日' WHERE DAY_NAME = 'Monday';
UPDATE SHJP.TIMES SET DAY_NAME = '火曜日' WHERE DAY_NAME = 'Tuesday';
UPDATE SHJP.TIMES SET DAY_NAME = '水曜日' WHERE DAY_NAME = 'Wednesday';
UPDATE SHJP.TIMES SET DAY_NAME = '木曜日' WHERE DAY_NAME = 'Thursday';
UPDATE SHJP.TIMES SET DAY_NAME = '金曜日' WHERE DAY_NAME = 'Friday';
UPDATE SHJP.TIMES SET DAY_NAME = '土曜日' WHERE DAY_NAME = 'Saturday';
UPDATE SHJP.TIMES SET DAY_NAME = '日曜日' WHERE DAY_NAME = 'Sunday';

COMMIT;


INSERT INTO SHJP.SALES SELECT * FROM SH.SALES;
INSERT INTO SHJP.COSTS SELECT * FROM SH.COSTS;

COMMIT;

update shjp.sales set amount_sold=amount_sold*100;
update shjp.costs set unit_cost=unit_cost*100;
update shjp.costs set unit_price=unit_price*100;
update shjp.products set prod_list_price=prod_list_price*100;

COMMIT;


SELECT 'CHANNELS' as TNAME,count(*) from SHJP.CHANNELS union
SELECT 'COSTS' as TNAME,count(*) from SHJP.COSTS union
SELECT 'COUNTRIES' as TNAME,count(*) from SHJP.COUNTRIES union
SELECT 'CUSTOMERS' as TNAME,count(*) from SHJP.CUSTOMERS union
SELECT 'PRODUCTS' as TNAME,count(*) from SHJP.PRODUCTS union
SELECT 'PROMOTIONS' as TNAME,count(*) from SHJP.PROMOTIONS union
SELECT 'SALES' as TNAME,count(*) from SHJP.SALES union
SELECT 'TIMES' as TNAME,count(*) from SHJP.TIMES ;



----------------------------
--  UPDATE TIMES.TIME_ID  --
--  UPDATE SALES.TIME_ID  --
--  UPDATE COSTS.TIME_ID  --
----------------------------

spool c:\UpdateSH.log;

-- 1. FKを無効化
ALTER TABLE SHJP.SALES DISABLE CONSTRAINT SALES_TIME_FK;
ALTER TABLE SHJP.COSTS DISABLE CONSTRAINT COSTS_TIME_FK;

-- 2. TIMES.TIME_IDを現在まで増やす
UPDATE SHJP.TIMES SET TIME_ID = TIME_ID + (to_date('20191231','yyyymmdd')-to_date('20011231','yyyymmdd'));

-- 3. TIMESのTIME_ID以外のカラムをTIME_IDに合わせる
UPDATE SHJP.TIMES set
 DAY_NAME = to_char(time_id,'DY')
,DAY_NUMBER_IN_WEEK = MOD(TO_CHAR(time_id,'D')+6,7)
,DAY_NUMBER_IN_MONTH = to_char(time_id,'DD')
,CALENDAR_WEEK_NUMBER = to_char(time_id,'IW')
,WEEK_ENDING_DAY = trunc(time_id+7,'IW')-1
,WEEK_ENDING_DAY_ID = to_char(trunc(time_id+7,'IW')-1,'YYYYMMDD')
,CALENDAR_MONTH_NUMBER = to_char(time_id,'MM')
,CALENDAR_MONTH_DESC = to_char(time_id,'YY-MONTH')
,CALENDAR_MONTH_ID = to_char(time_id,'YYYYMM')
,DAYS_IN_CAL_MONTH = to_char(last_Day(time_id),'DD')
,END_OF_CAL_MONTH = last_Day(time_id)
,CALENDAR_MONTH_NAME = to_char(time_id,'MONTH')
,CALENDAR_QUARTER_DESC = to_char(time_id,'YYYY-Q')
,CALENDAR_QUARTER_ID = to_char(time_id,'YYYYQ')
,DAYS_IN_CAL_QUARTER = last_day(add_months(trunc(time_id,'Q'),2))-trunc(time_id,'Q')+1
,END_OF_CAL_QUARTER = last_day(add_months(trunc(time_id,'Q'),2))
,CALENDAR_QUARTER_NUMBER = to_char(time_id,'Q')
,CALENDAR_YEAR = to_char(time_id,'YYYY')
,CALENDAR_YEAR_ID = to_char(time_id,'YYYY')
,DAYS_IN_CAL_YEAR = 1+LAST_DAY(ADD_MONTHS(TRUNC(time_id,'YEAR'),11))-TRUNC(time_id,'YEAR')
,END_OF_CAL_YEAR = LAST_DAY(ADD_MONTHS(TRUNC(time_id,'YEAR'),11))
;


commit;

-- 4. SH.SALESをTRUNCATE
DROP TABLE SHJP.SALES_TMP PURGE;
CREATE TABLE SHJP.SALES_TMP AS SELECT * FROM SHJP.SALES;
TRUNCATE TABLE SHJP.SALES;

-- 6. SALESの日付データをUPDATE

INSERT INTO SHJP.SALES
SELECT
 PROD_ID
,CUST_ID
,TIME_ID + (to_date('20191231','yyyymmdd')-to_date('20011231','yyyymmdd'))
,CHANNEL_ID
,PROMO_ID
,QUANTITY_SOLD
,AMOUNT_SOLD
FROM SHJP.SALES_TMP
;

DROP TABLE SHJP.SALES_TMP CASCADE CONSTRAINT PURGE;

-- 7. FKを有効化
-- ALTER TABLE SHJP.SALES ENABLE NOVALIDATE CONSTRAINT SHJP.SALES_TIME_FK;
-- COMMIT;

------ COSTSの更新 ------
-- COSTSをTRUNCATE
DROP TABLE SHJP.COSTS_TMP PURGE;
CREATE TABLE SHJP.COSTS_TMP AS SELECT * FROM SHJP.COSTS;
TRUNCATE TABLE SHJP.COSTS;

-- COSTSの日付データをUPDATE。

INSERT INTO SHJP.COSTS
SELECT
 PROD_ID
,TIME_ID + (to_date('20191231','yyyymmdd')-to_date('20011231','yyyymmdd'))
,PROMO_ID
,CHANNEL_ID
,UNIT_COST
,UNIT_PRICE
FROM SHJP.COSTS_TMP
;

DROP TABLE SHJP.COSTS_TMP CASCADE CONSTRAINT PURGE;

-- FKを有効化
-- ALTER TABLE SHJP.COSTS ENABLE NOVALIDATE CONSTRAINT COSTS_TIME_FK;
-- COMMIT;


-- ↓ Error
alter session set NLS_DATE_LANGUAGE='JAPANESE';
update shjp.times set
 DAY_NAME			= substr(to_char(time_id,'DAY'),1,1)
,DAY_NUMBER_IN_WEEK		= to_char(time_id,'D')-1
,DAY_NUMBER_IN_MONTH		= to_char(time_id,'DD')
,CALENDAR_WEEK_NUMBER		= to_char(time_id,'WW')
,FISCAL_WEEK_NUMBER		= FISCAL_WEEK_NUMBER
,WEEK_ENDING_DAY		= next_day(time_id-1,'日曜日')
,WEEK_ENDING_DAY_ID		= to_char(next_day(time_id-1,'日曜日'),'yyyymmdd')
,CALENDAR_MONTH_NUMBER		= to_char(time_id, 'MM')
,FISCAL_MONTH_NUMBER		= to_char(time_id, 'MM')
,CALENDAR_MONTH_DESC		= to_char(time_id,'yyyy-mm')
,CALENDAR_MONTH_ID		= to_char(time_id,'yyyymm')
,FISCAL_MONTH_DESC		= case 
					when to_char(time_id,'mm')<=3 then to_char(add_months(time_id,-12),'yyyy-mm')
					else to_char(time_id,'yyyy-mm')
				  end
,FISCAL_MONTH_ID		= case 
					when to_char(time_id,'mm')<=3 then to_char(time_id,'yyyymm')
					when to_char(time_id,'mm')> 3 then to_char(time_id,'yyyymm')
				  end
,DAYS_IN_CAL_MONTH		= to_char(last_day(time_id),'dd')
,DAYS_IN_FIS_MONTH		= to_char(last_day(time_id),'dd')
,END_OF_CAL_MONTH		= last_day(time_id)
,END_OF_FIS_MONTH		= last_day(time_id)
,CALENDAR_MONTH_NAME		= rtrim(to_char(time_id,'month'))
,FISCAL_MONTH_NAME		= rtrim(to_char(time_id,'month'))
,CALENDAR_QUARTER_DESC		= to_char(time_id,'"Q"q')
,CALENDAR_QUARTER_ID		= to_char(time_id,'yyyyq')
,FISCAL_QUARTER_DESC		= to_char(add_months(time_id,-3),'"Q"q')
,FISCAL_QUARTER_ID		= to_char(add_months(time_id,-3),'yyyyq')
,DAYS_IN_CAL_QUARTER		= trunc(add_months(time_id,3),'q')-trunc(time_id,'q')
,DAYS_IN_FIS_QUARTER		= trunc(add_months(time_id,3),'q')-trunc(time_id,'q')
,END_OF_CAL_QUARTER		= trunc(add_months(time_id,3),'q')-1
,END_OF_FIS_QUARTER		= trunc(add_months(time_id,3),'q')-1
,CALENDAR_QUARTER_NUMBER	= to_char(time_id,'q')
,FISCAL_QUARTER_NUMBER		= to_char(add_months(time_id,-3),'q') 
,CALENDAR_YEAR			= to_char(time_id,'yyyy')
,CALENDAR_YEAR_ID		= to_char(time_id,'yyyy')
,FISCAL_YEAR			= to_char(add_months(time_id,-3),'yyyy')
,FISCAL_YEAR_ID			= to_char(add_months(time_id,-3),'yyyy')
,DAYS_IN_CAL_YEAR		= to_char(to_date(to_char(time_id,'yyyy')||'1231','yyyymmdd'),'ddd')
,DAYS_IN_FIS_YEAR		= to_date(to_char(add_months(time_id,9),'yyyy')||'0331','yyyymmdd') -
					to_date(to_char(add_months(time_id,-3),'yyyy')||'0331','yyyymmdd')
,END_OF_CAL_YEAR		= to_date(to_char(time_id,'yyyy')||'1231','yyyymmdd')
,END_OF_FIS_YEAR		= to_date(to_char(add_months(time_id,9),'yyyy')||'0331','yyyymmdd')
;

update times set DAY_NUMBER_IN_WEEK = 7 where DAY_NUMBER_IN_WEEK = 0;

commit;


SELECT 'CHANNELS' as TNAME,count(*) from SHJP.CHANNELS union
SELECT 'COSTS' as TNAME,count(*) from SHJP.COSTS union
SELECT 'COUNTRIES' as TNAME,count(*) from SHJP.COUNTRIES union
SELECT 'CUSTOMERS' as TNAME,count(*) from SHJP.CUSTOMERS union
SELECT 'PRODUCTS' as TNAME,count(*) from SHJP.PRODUCTS union
SELECT 'PROMOTIONS' as TNAME,count(*) from SHJP.PROMOTIONS union
SELECT 'SALES' as TNAME,count(*) from SHJP.SALES union
SELECT 'TIMES' as TNAME,count(*) from SHJP.TIMES ;

~~~