create table xt_cm3000_bak as select * from xt_cm3000;
create table cm3_temp (cm3000 varchar2(40),SSMC00 varchar2(200),fl0000 varchar2(40));
create unique index cm3_temp on cm3_temp(cm3000);
alter table xt_cm3000 add (sfyx00 char(1));
update xt_cm3000 set sfyx00='1' where sfyx00 is null;
alter table xt_cm3000 modify (sfyx00 default '1');
commit;
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.01001','頭部血管治療性超聲','治療性操作');
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.01002','頸部血管治療性超聲','治療性操作');
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.02001','心臟治療性超聲','治療性操作');
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.03001','周圍血管治療性超聲','治療性操作');
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.10001','化學治療藥物置入','治療性操作');
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.11001','輸注重組蛋白','治療性操作');
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.12001','一氧化氮療法','治療性操作');
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.13001','輸注人類B型鈉尿肽[hBNP]','治療性操作');
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.14001','注射噁唑烷酮類抗生素','治療性操作');
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.15001','輸注白細胞介素','治療性操作');
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.15002','注射阿地白細胞介素','治療性操作');
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.16001','藥物靜脈旁路移植加壓療法','治療性操作');
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.16002','經活體外血管治療','治療性操作');
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.16003','高壓移植[引導]','治療性操作');
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.17001','灌注血管加壓劑','治療性操作');
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.18001','單克隆抗體治療','治療性操作');
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.18002','多克隆抗體治療','治療性操作');
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.21002','頸動脈血管內超聲[IVUS]','診斷性操作');
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.21003','顱外腦血管血管內超聲[IVUS]','診斷性操作');
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.22002','胸內血管血管內超聲[IVUS]','診斷性操作');
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.22003','胸主動脈血管內超聲[IVUS]','診斷性操作');
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.23002','周圍血管血管內超聲[IVUS]','診斷性操作');
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.23003','臂血管血管內超聲[IVUS]','診斷性操作');
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.23004','腿血管血管內超聲[IVUS]','診斷性操作');
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.24001','冠狀動脈血管內超聲[IVUS]','診斷性操作');
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.25002','腎血管血管內超聲[IVUS]','診斷性操作');
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.29001','血管內超聲','診斷性操作');
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.31001','計算機CT/CTA輔助外科','治療性操作');
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.32001','神經導航輔助外科MR/MRA','治療性操作');
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.33001','計算機熒光透視輔助外科','治療性操作');
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.34001','無顯像導航計算機輔助外科','治療性操作');
insert into cm3_temp (CM3000,SSMC00,FL0000) values ('00.35001','顯像導航計算機輔助外科','治療性操作'); |
|