SET sql_create = 'create table zjb as ( select groupid from(select '||IN_FOCUSFIELD||',rank() over(order by '||IN_GROUPBY||' as groupid from '||IN_TBNAME||' a group by groupid having max(cast('||IN_FOCUSFIELD||'as int)) - min(cast('||IN_FO...
显示全部SET sql_create = 'create table zjb as ( select groupid from(select '||IN_FOCUSFIELD||',rank() over(order by '||IN_GROUPBY||' as groupid from '||IN_TBNAME||' a group by groupid having max(cast('||IN_FOCUSFIELD||'as int)) - min(cast('||IN_FOCUSFIELD||' as int)) >= '||V_TRENDSTEP||')))' || 'definition only IN ' ||IN_TABLESPACE|| ' INDEX IN ' ||IN_INDEXSPACE|| ' not logged initially';
这里面的V_TRENDSTEP旁边老是报错,两边一个单引号报错,三个单引号还是报错,大婶们救命啊~~~~
附上存储过程附件
附件:
s.sql (3.4 KB)
收起