摘要:
1、oracle在执行静态sql的时候会做语法校验并声称执行计划错误: declarel_sqlvarchar2(2000);l_flagint;beginselectcount(*)intol_flagfromuser_tableswheretable_name=upper('table_name... 阅读全文
摘要:
declare l_flag int;begin select count(*) into l_flag from user_tables where table_name = upper('ops_zd_status'); IF l_flag = 0 then execute immediate ... 阅读全文