程序代码：

insert into t_xs_jjcl_rz
(id,rq,ch,cp_id,cp_name,kh_id,kh_name,user_id,user_name) 
values
(
(select decode(max(to_number(id)),null,0,max(to_number(id)))+1 from t_xs_jjcl_rz),
'2011-08-30 11:16',
(select ch from t_qc_bzpzb WHERE gxtype=0 and CH='111'),
(select cp_id from t_xs_CH_JSDW WHERE rownum<=1 and CH='111' order by ch,kh_id),
(select cp_name from t_xs_CH_JSDW WHERE rownum<=1 and CH='111' order by ch,kh_id),
(select kh_id from t_xs_CH_JSDW WHERE rownum<=1 and CH='111' order by ch,kh_id),
(select kh_name from t_xs_CH_JSDW WHERE rownum<=1 and CH='111' order by ch,kh_id),
1,
(select name from t_um_user where id=1)
)

程序代码：

insert into t_xs_jjcl_rz
(id,rq,ch,cp_id,cp_name,kh_id,kh_name,user_id,user_name) 
values
(
(select decode(max(to_number(id)),null,0,max(to_number(id)))+1 from t_xs_jjcl_rz),
'2011-08-30 11:16',
(select ch from t_qc_bzpzb WHERE gxtype=0 and CH='111'),
(select cp_id from (select cp_id from t_xs_CH_JSDW WHERE rownum<=1 and CH='111' order by ch,kh_id)),
(select cp_name from (select cp_name from t_xs_CH_JSDW WHERE rownum<=1 and CH='111' order by ch,kh_id)),
(select kh_id from (select kh_id from t_xs_CH_JSDW WHERE rownum<=1 and CH='111' order by ch,kh_id)),
(select kh_name from (select kh_name from t_xs_CH_JSDW WHERE rownum<=1 and CH='111' order by ch,kh_id)),
1,
(select name from t_um_user where id=1)
)