如图所示 直接给实际值又不会报错,这是为什么呢?
用动态sql拼Para_Days，例如： _sql = ‘select xxx from dual where (curdate()-interval ‘’’||i||‘’’ day) <=c.UploadDate’; exec immediate _sql;
用动态sql拼Para_Days，例如：
_sql = ‘select xxx from dual where (curdate()-interval ‘’’||i||‘’’ day) <=c.UploadDate’;
exec immediate _sql;