+ -
当前位置:首页 → 问答吧 → ORACLE:动态SQL问题

ORACLE:动态SQL问题

时间:2011-09-14

来源:互联网

DECLARE
V_CNT NUMBER :=0;
BEGIN 
 V_SQL:= 'SELECT COUNT(*) INTO V_CNT1
  FROM ZB_SRC.ZB_D_BIDWMB05007_'||V_PROV||' WHERE MONTH_ID=''201109'' AND DAY_ID=''01'' AND ROWNUM<10';
 EXECUTE IMMEDIATE V_SQL;
END;
报错 ORA-00905: missing keyword
求达人解答 多谢

作者: linjun54321   发布时间: 2011-09-14

把“V_CNT NUMBER :=0;”改成“V_CNT NUMBER default 0;”

作者: wawxj   发布时间: 2011-09-14

SQL code
DECLARE
V_CNT NUMBER :=0;
BEGIN  
 V_SQL:= 'SELECT COUNT(*) 
  FROM ZB_SRC.ZB_D_BIDWMB05007_'||V_PROV||' WHERE MONTH_ID=''201109'' AND DAY_ID=''01'' AND ROWNUM<10';
 EXECUTE IMMEDIATE V_SQL into V_CNT ;
END;

作者: renfengjun   发布时间: 2011-09-14