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','显像导航计算机辅助外科','治疗性操作'); |
|
资源大小：48.70 KB 
