Posted on 2007-09-05 14:49
匪客 閱讀(11404)
評論(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函數。