我哪里缺少右括号了？？？？求助 - Oracle论坛

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) )

第 2 楼

得分:0

已解决！
可能是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)
)