Posted on 2007-09-05 14:49
匪客 阅读(11396)
评论(2) 编辑 收藏 所属分类:
数据库
insert into expertinfo
(expertid,expertname,expertcode,sex,enabled)
select
primarykey as expertid,
name as expertname,
'' as expertcode,
case sex when '男' then '1' when '0' then '女' end as sex,
'0' as ENABLED
from experttmp
其中primarykey 是生成主键的Oracle函数。