ORA-00936: 缺失表达式

SELECt
*
FROM SYSTEM_PARAMETER SP
WHERe
SP.PARAM_DESC = 'bandWidthList' AND SP.PARAM_VALUE IN
(SELECt
DISTINCT ATT.MAX_BAND
FROM
ACCOUNT_TYPE ATT
WHERe
ATT.TYPE_ID IN
(SELECt
CAT.ACCOUNT_TYPE_ID
FROM
COMM_ACCOUNT_TYPE CAT
WHERe
(CAT.COMMUNITY_ID = 0 OR CAT.COMMUNITY_ID = -
(SELECt
COMM.CENTER_ID
FROM
COMM_INFO COMM
WHERe
COMM.COMM_ID = (
SELECt UI.COMMUNITY_ID
FROM
USER_INFO UI
WHERe

UI.ACCOUNT_ID=#accountId#

))OR CAT.COMMUNITY_ID = (
SELECt
UI.COMMUNITY_ID
FROM
USER_INFO UI
WHERe

UI.ACCOUNT_ID=#accountId#

)))
AND ATT.MAX_BAND > (
SELECt
ATT.MAX_BAND
FROM ACCOUNT_TYPE ATT
WHERe ATT.ID IN (
SELECt
UI.ACCOUNTTYPE_ID
FROM
USER_INFO UI
WHERe

UI.ACCOUNT_ID = #accountId#

)) AND ATT.STATUS=0)

insert into tcddbqb (danwei,chexing,chehao,jiashiyuan,bqqk,beizhu,riqi) values('{0}','{1}','{2}','{3}','{4}','{5}',date())", ddl1.SelectedValue.ToString(), ddl2.SelectedValue.ToString(), ddl3.SelectedValue.ToString(), ddl4.SelectedValue.ToString(), rbl1.SelectedItem.Text, textboxbz.Text,"");

1.values的最后一个date()，既然取系统时间，那么""可以去掉了
2.保证date()是oracle的系统函数

d_begin_time varchar2(100;少了个右括号 另外，execute immediate 'select sysdate into '|| d_begin_time||' from dual';写法有问题。 正确如下： declare d_begin_time varchar2(100); begin execute immediate 'select sysdate from dual' into d_begin_time; end;