VB ADODB.Recordset
SQL中使用了union 关键安会提示ORA-00933 SQL命令未正确结束。
select distinct to_char(sysdate + rownum-1, 'yyyyiw') weekno from dual connect by rownum <= 365
union
select distinct to_char(sysdate - rownum-1, 'yyyyiw') weekno from dual connect by rownum <= 365
SQL中使用了union 关键安会提示ORA-00933 SQL命令未正确结束。
select distinct to_char(sysdate + rownum-1, 'yyyyiw') weekno from dual connect by rownum <= 365
union
select distinct to_char(sysdate - rownum-1, 'yyyyiw') weekno from dual connect by rownum <= 365
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货