SELECT TABLE1.TARGET_ID
FROM TABLE1
WHERE TABLE1.TARGET_ID=10001
GROUP BY
TABLE1.TARGET_ID
order by TABLE1.TARGET_ID;
spo off;
...全文
12717打赏收藏
运行SQL出错,请大虾们帮忙,给力100分
错误提示: ORA-00900:INVALID SQL STATEMENT 脚本如下: spool e:\123..csv SELECT TABLE1.TARGET_ID FROM TABLE1 WHERE TABLE1.TARGET_ID=10001 GROUP BY TABLE1.TARGET_ID order by TABLE1.TARGET_ID; spo off;
SPOOL命令是没有问题的。可以简写成SPO;
把你的SQL语句重新复制执行一下看
SELECT TABLE1.TARGET_ID
FROM TABLE1
WHERE TABLE1.TARGET_ID=10001
GROUP BY
TABLE1.TARGET_ID
order by TABLE1.TARGET_ID;
spool e:\123.csv
select * from (SELECT TABLE1.TARGET_ID
FROM TABLE1
WHERE TABLE1.TARGET_ID=10001
GROUP BY
TABLE1.TARGET_ID)
order by TARGET_ID;
spool off;