在查询语句里先输入spool filepath 中间是需要查询的语句,最后spool off 就会把中间查询的结果都输入到file文件里
spool E:\log.txt;
select id,name from users;
spool off;
原文链接:https://blog.csdn.net/qq_42719108/article/details/82230036?spm=1001.2101.3001.6650.4&utm_medium=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7ERate-4-82230036-blog-82543978.pc_relevant_default&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7ERate-4-82230036-blog-82543978.pc_relevant_default&utm_relevant_index=6