|
#2
观星2011-08-30 12:32
已解决！
可能是order by 的问题 我把语句改成这样的就可以执行了  程序代码：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) ) |
程序代码：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)
)
(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)
)
提示我缺少右括号，我没少啊。。。大家能帮我看看么，谢谢！