★☆★☆★求实现该功能一条sql语句★☆★☆

[zhouziqiang]

TBlackInfo表是空的，里面至少有这两个字段（FCarNo，FCarType），我要把SAJDCDJ表中两个字段（JDCLX，CPHM）的全部记录插入到TBlackInfo表中，就是将CPHM里的内容插入插入到FCarNo字段里，把JDCLX里的内容转换后插入FCarType里，
JDCLX里的内容为代码标记，如K11，K32 ，K14等，要将标记转换成汉字后插入TBlackInfo的FCarType字段里，具体转换规则如下：

K11 大型普通客车
K12 大型双层客车
K13 大型卧铺客车
K14 大型铰接客车
K15 大型越野客车
K21 中型普通客车
K22 中型双层客车
K23 中型卧铺客车
K24 中型铰接客车
K25 中型越野客车
K31 小型普通客车
K32 小型越野客车
K33 轿车
K41 微型普通客车
K42 微型越野客车
K43 微型轿车
H11 重型普通货车
H12 重型厢式货车
H13 重型封闭货车
H14 重型罐式货车
H15 重型平板货车
H16 重型集装厢车
H17 重型自卸货车
H18 重型特殊结构货车
H21 中型普通货车
H22 中型厢式货车
H23 中型封闭货车
H24 中型罐式货车
H25 中型平板货车
H26 中型集装厢车
求实现该功能一条sql语句，请问该如何实现！！
请赐教!!

[hongqi162]

insert into TBlackInfo (FCarNo,FCarType) select JDCLX，CPHM from SAJDCDJ;

[letqqqgo]

这样转换一下，直接拿去用：
insert into TBlackInfo (FCarNo,FCarType)
select decode(jdclx,'K11','大型普通客车','K12','大型双层客车','K13','大型卧铺客车',
'K14','大型铰接客车','K15','大型越野客车','K21','中型普通客车','K22','中型双层客车',
'K23','中型卧铺客车','K24','中型铰接客车','K25','中型越野客车','K31','小型普通客车',
'K32','小型越野客车','K33','轿车','K41','微型普通客车','K42','微型越野客车','K43',
'微型轿车','H11','重型普通货车','H12','重型厢式货车','H13','重型封闭货车','H14','重型罐式货车',
'H15','重型平板货车','H16','重型集装厢车','H17','重型自卸货车','H18','重型特殊结构货车',
'H21','中型普通货车','H22','中型厢式货车','H23','中型封闭货车','H24','中型罐式货车','H25',
'中型平板货车','H26','中型集装厢车',null),
cphm
from sajdcdj;

[hongqi162]

你的FCarType在车管库中应该叫交通方式，你应该创建一个表来保存这些信息，我家里保存的脚本只有这几个

insert into parameter (p_id,parameterno,parametervalue,ptype) values(33,'B11','中型普通半挂车',2);
insert into parameter (p_id,parameterno,parametervalue,ptype) values(34,'B12','重型厢式半挂车',2);
insert into parameter (p_id,parameterno,parametervalue,ptype) values(35,'B13','重型灌式半挂车',2);
insert into parameter (p_id,parameterno,parametervalue,ptype) values(36,'B14','重型平板半挂车',2);
insert into parameter (p_id,parameterno,parametervalue,ptype) values(37,'B15','重型集装箱半挂车',2);
insert into parameter (p_id,parameterno,parametervalue,ptype) values(38,'B16','重型自卸半挂车',2);

[CathySun118]

insert into TBlackInfo (FCarNo,FCarType) select JDCLX，CPHM from SAJDCDJ;

[hongqi162]

prompt PL/SQL Developer import file
prompt Created on 2007年4月18日 by Administrator
set feedback off
set define off
prompt Loading TEMP1234...
insert into TEMP1234 (CID, CNAME)
values ('Z41', '微型专项作业车');
insert into TEMP1234 (CID, CNAME)
values ('Z51', '重型专项作业车');
insert into TEMP1234 (CID, CNAME)
values ('Z71', '轻型专项作业车');
insert into TEMP1234 (CID, CNAME)
values ('M21', '普通二轮摩托车');
insert into TEMP1234 (CID, CNAME)
values ('M22', '轻便二轮摩托车');
insert into TEMP1234 (CID, CNAME)
values ('N21', '四轮农用普通货车');
insert into TEMP1234 (CID, CNAME)
values ('N22', '四轮农用厢式货车');
insert into TEMP1234 (CID, CNAME)
values ('N23', '四轮农用罐式货车');
insert into TEMP1234 (CID, CNAME)
values ('N24', '四轮农用自卸货车');
insert into TEMP1234 (CID, CNAME)
values ('Q11', '重型半挂牵引车');
insert into TEMP1234 (CID, CNAME)
values ('Q21', '中型半挂牵引车');
insert into TEMP1234 (CID, CNAME)
values ('Q31', '轻型半挂牵引车');
insert into TEMP1234 (CID, CNAME)
values ('T11', '大型轮式拖拉机');
insert into TEMP1234 (CID, CNAME)
values ('T31', '小型轮式拖拉机');
insert into TEMP1234 (CID, CNAME)
values ('T32', '手扶拖拉机');
insert into TEMP1234 (CID, CNAME)
values ('T33', '手扶变形运输机');
insert into TEMP1234 (CID, CNAME)
values ('Z11', '大型专项作业车');
insert into TEMP1234 (CID, CNAME)
values ('Z21', '中型专项作业车');
insert into TEMP1234 (CID, CNAME)
values ('Z31', '小型专项作业车');
insert into TEMP1234 (CID, CNAME)
values ('G23', '中型罐式全挂车');
insert into TEMP1234 (CID, CNAME)
values ('G24', '中型平板全挂车');
insert into TEMP1234 (CID, CNAME)
values ('G25', '中型集装箱全挂车');
insert into TEMP1234 (CID, CNAME)
values ('G26', '中型自卸全挂车');
insert into TEMP1234 (CID, CNAME)
values ('G31', '轻型普通全挂车');
insert into TEMP1234 (CID, CNAME)
values ('G32', '轻型厢式全挂车');
insert into TEMP1234 (CID, CNAME)
values ('G33', '轻型罐式全挂车');
insert into TEMP1234 (CID, CNAME)
values ('G34', '轻型平板全挂车');
insert into TEMP1234 (CID, CNAME)
values ('G35', '轻型自卸全挂车');
insert into TEMP1234 (CID, CNAME)
values ('H11', '重型普通货车');
insert into TEMP1234 (CID, CNAME)
values ('H12', '重型厢式货车');
insert into TEMP1234 (CID, CNAME)
values ('H14', '重型罐式货车');
insert into TEMP1234 (CID, CNAME)
values ('H16', '重型集装厢车');
insert into TEMP1234 (CID, CNAME)
values ('H21', '中型普通货车');
insert into TEMP1234 (CID, CNAME)
values ('H22', '中型厢式货车');
insert into TEMP1234 (CID, CNAME)
values ('H23', '中型封闭货车');
insert into TEMP1234 (CID, CNAME)
values ('H24', '中型罐式货车');
insert into TEMP1234 (CID, CNAME)
values ('H25', '中型平板货车');
insert into TEMP1234 (CID, CNAME)
values ('H26', '中型集装厢车');
insert into TEMP1234 (CID, CNAME)
values ('H27', '中型自卸货车');
insert into TEMP1234 (CID, CNAME)
values ('H28', '中型特殊结构货车');
insert into TEMP1234 (CID, CNAME)
values ('H31', '轻型普通货车');
insert into TEMP1234 (CID, CNAME)
values ('H32', '轻型厢式货车');
insert into TEMP1234 (CID, CNAME)
values ('H33', '轻型封闭货车');
insert into TEMP1234 (CID, CNAME)
values ('H34', '轻型罐式货车');
insert into TEMP1234 (CID, CNAME)
values ('H42', '微型厢式货车');
insert into TEMP1234 (CID, CNAME)
values ('H44', '微型罐式货车');
insert into TEMP1234 (CID, CNAME)
values ('H45', '微型自卸货车');
insert into TEMP1234 (CID, CNAME)
values ('H46', '微型特殊结构货车');
insert into TEMP1234 (CID, CNAME)
values ('J11', '轮式装载机械');
insert into TEMP1234 (CID, CNAME)
values ('J12', '轮式挖掘机械');
insert into TEMP1234 (CID, CNAME)
values ('J13', '轮式平地机械');
insert into TEMP1234 (CID, CNAME)
values ('K12', '大型双层客车');
insert into TEMP1234 (CID, CNAME)
values ('K13', '大型卧铺客车');
insert into TEMP1234 (CID, CNAME)
values ('K14', '大型铰接客车');
insert into TEMP1234 (CID, CNAME)
values ('K15', '大型越野客车');
insert into TEMP1234 (CID, CNAME)
values ('K21', '中型普通客车');
insert into TEMP1234 (CID, CNAME)
values ('K22', '中型双层客车');
insert into TEMP1234 (CID, CNAME)
values ('K23', '中型卧铺客车');
insert into TEMP1234 (CID, CNAME)
values ('K24', '中型铰接客车');
insert into TEMP1234 (CID, CNAME)
values ('K31', '小型普通客车');
insert into TEMP1234 (CID, CNAME)
values ('K33', '轿车');
insert into TEMP1234 (CID, CNAME)
values ('K11', '大型普通客车');
insert into TEMP1234 (CID, CNAME)
values ('B12', '重型厢式半挂车');
insert into TEMP1234 (CID, CNAME)
values ('B13', '重型灌式半挂车');
insert into TEMP1234 (CID, CNAME)
values ('B14', '重型平板半挂车');
insert into TEMP1234 (CID, CNAME)
values ('B15', '重型集装箱半挂车');
insert into TEMP1234 (CID, CNAME)
values ('B16', '重型自卸半挂车');
insert into TEMP1234 (CID, CNAME)
values ('999', '其它');
insert into TEMP1234 (CID, CNAME)
values ('B11', '重型普通半挂车');
insert into TEMP1234 (CID, CNAME)
values ('B17', '重型特殊结构半挂车');
insert into TEMP1234 (CID, CNAME)
values ('B21', '中型普通半挂车');
insert into TEMP1234 (CID, CNAME)
values ('B22', '中型厢式半挂车');
insert into TEMP1234 (CID, CNAME)
values ('B23', '中型罐式半挂车');
insert into TEMP1234 (CID, CNAME)
values ('B24', '中型平板半挂车');
insert into TEMP1234 (CID, CNAME)
values ('B25', '中型集装箱半挂车');
insert into TEMP1234 (CID, CNAME)
values ('B26', '中型自卸半挂车');
insert into TEMP1234 (CID, CNAME)
values ('B27', '中型特殊结构半挂车');
insert into TEMP1234 (CID, CNAME)
values ('B31', '轻型普通半挂车');
insert into TEMP1234 (CID, CNAME)
values ('B32', '轻型厢式半挂车');
insert into TEMP1234 (CID, CNAME)
values ('B33', '轻型罐式半挂车');
insert into TEMP1234 (CID, CNAME)
values ('B34', '轻型平板半挂车');
insert into TEMP1234 (CID, CNAME)
values ('B35', '轻型自卸半挂车');
insert into TEMP1234 (CID, CNAME)
values ('D12', '有轨电车');
insert into TEMP1234 (CID, CNAME)
values ('G11', '重型普通全挂车');
insert into TEMP1234 (CID, CNAME)
values ('G12', '重型厢式全挂车');
insert into TEMP1234 (CID, CNAME)
values ('G13', '重型罐式全挂车');
insert into TEMP1234 (CID, CNAME)
values ('G14', '重型平板全挂车');
insert into TEMP1234 (CID, CNAME)
values ('G15', '重型集装箱全挂车');
insert into TEMP1234 (CID, CNAME)
values ('G22', '中型厢式全挂车');
commit;
prompt 89 records loaded
set feedback on
set define on
prompt Done.

[hyrongg]

转换规则应该存在一张编码表里面，
然后写一个函数，不然如果以后你需要更新你的
转换规则，就需要重写SQL,维护起来会死人的；