|
·ÖÀർº½ |
 |
|
|
|
|
×ÊÔ´´óС£º189.34 KB |
×ÊÔ´ÀàÐÍ£ºÎĵµ |
ÏÂÔØ»ý·Ö£º 0 |
|
|
|
×ÊÔ´½éÉÜ |
|
--×¢ÒâÊÂÏÔËÐнű¾Ç°£¬ÇëÈ·¶¨Ò½ÔºÊÇ·ñÓÐ×ÔÐÐÔö¼ÓµÄбàÂ룬Èç¹û×ÔÐÐÔö¼ÓµÄбàÂëÓë×îбê×¼³åÍ»£¬±¾½Å±¾»á°´Ð±ê×¼Ö´ÐС£×ÔÐÐÔö¼ÓµÄ±àÂ뽫±»Çå³ý¡£
drop table xt_icd100;
create synonym xt_icd100 for xt_icd900;
create table xt_icd100_ver1 as select * from xt_icd100;
alter table xt_icd900 modify JBMC00 varchar2(100);
create table icd_temp (icd100 varchar2(40),fzm000 varchar2(40),jbmc00 varchar2(200));
create unique index idx_temp on icd_temp(icd100);
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A00.001',NULL,'¹ÅµäÉúÎïÐÍ»ôÂÒ');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A00.101',NULL,'°£¶ûÍÐÉúÎïÐÍ»ôÂÒ');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A00.901',NULL,'»ôÂÒ');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A00.902',NULL,'»ôÂÒÇáÐÍ');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A00.903',NULL,'»ôÂÒÖÐÐÍ');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A00.904',NULL,'»ôÂÒÖØÐÍ');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A00.905',NULL,'»ôÂÒ±©·¢ÐÍ');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.001',NULL,'É˺®');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.002',NULL,'É˺®¸Ë¾ú°ÜѪ֢');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.003+','G01*','É˺®²¢·¢ÄÔĤÑ×');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.004',NULL,'É˺®¸´·¢');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.005+','J17.0*','É˺®²¢·¢·ÎÑ×');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.006',NULL,'É˺®Ç¨ÑÓÐÍ');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.007',NULL,'É˺®åÐÒ£ÐÍ');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.008',NULL,'É˺®²¢·¢¸¹Ä¤Ñ×');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.009',NULL,'É˺®²¢·¢³¦´©¿×');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.010',NULL,'É˺®²¢·¢³¦³öѪ');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.011',NULL,'É˺®²¢·¢Öж¾ÐÔ¸ÎÑ×');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.012',NULL,'É˺®²¢·¢Ö§Æø¹ÜÑ×');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.014',NULL,'É˺®²¢·¢µ¨ÄÒÑ×');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.016+','I41.0*','É˺®²¢·¢Öж¾ÐÔÐļ¡Ñ×');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.017',NULL,'É˺®ÇáÐÍ');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.018',NULL,'É˺®ÆÕͨÐÍ');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.019',NULL,'É˺®±©·¢ÐÍ');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.020',NULL,'É˺®ÔÙȼ');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.101',NULL,'¸±É˺®¼×');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.201',NULL,'¸±É˺®ÒÒ');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.301',NULL,'¸±É˺®±û');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.401',NULL,'¸±É˺®');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A02.001',NULL,'ɳÞú³¦Ñ×');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A02.002',NULL,'ɳÞú賦Ñ×');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A02.003',NULL,'ɳÞúÂ×¶ØÑªÇåÐͳ¦Ñ×');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A02.004',NULL,'ÊóÉ˺®É³Ãžú³¦Ñ×');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A02.005',NULL,'Ó¤¶ùɳÞú³¦Ñ×');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A02.006',NULL,'CȺɳÞú³¦Ñ×');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A02.007',NULL,'BȺɳÞú³¦Ñ×');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A02.008',NULL,'°¢¸çÀɳÞú³¦Ñ×'); |
|
ÏÂÔØµØÖ· |
|
|
|
|
|