下面是我的出错代码:
dynamic_sql := 'select t3.departmentcode, t3.total from (select departmentcode,count(*) total from ' || str_tablename || ' where and departmentcode is not NULL group by departmentcode) t3,v_s_data_input_dept_usernum t4 where t3.departmentcode = ' || str_departmentcode || '';
更正后,执行成功的代码:
dynamic_sql := 'select t3.departmentcode, t3.total from (select departmentcode,count(*) total from ' || str_tablename || ' where and departmentcode is not NULL group by departmentcode) t3,v_s_data_input_dept_usernum t4 where t3.departmentcode = ' || str_departmentcode || '';
红色的部分对比
希望对出现类似错误的有所帮助
还有第二种情况
(Oracle测试)使用SQL语句的select语句是经常会用到字段和表的的别名,使用要注意,字段的别名前面可以加as关键字,或是省略不写,但是表名的别名前面不可以加as,否则会报如下错误:
命令出错, 行: 11 列: 20
错误报告:
SQL 错误: ORA-00907: 缺失右括号
00907. 00000 - "missing right parenthesis"
*Cause:
*Action: