问题描述
我尝试过
select * from users
save D:\test.sql create;
但是SQL plus给我没有正确的结局"如何在Windows中的oracle sql中指定路径?
But SQL plus gives me "no proper ended"How to specify path in oracle sql in windows?
推荐答案
使用线轴:
spool myoutputfile.txt
select * from users;
spool off;
请注意,这将在您运行SQL * Plus的目录中创建myoutputfile.txt.
Note that this will create myoutputfile.txt in the directory from which you ran SQL*Plus.
如果您需要在SQLPlus启动时从SQL文件(例如"tmp.sql")运行此文件并将其输出到名为"output.txt"的文件中,请执行以下操作:
If you need to run this from a SQL file (e.g., "tmp.sql") when SQLPlus starts up and output to a file named "output.txt":
tmp.sql:
select * from users;
命令:
sqlplus -s username/password@sid @tmp.sql > output.txt
请介意,我现在没有Oracle实例,因此您可能需要做一些自己的工作才能调试我从内存中写的内容.
Mind you, I don't have an Oracle instance in front of me right now, so you might need to do some of your own work to debug what I've written from memory.
这篇关于如何在Windows中将oracle sql结果输出到文件中?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!