blocks|key|1900590|text|您可以使用spool+command+(+SQL+*Plus文档，但SQL+Developer也支持许多这样的命令之一)将结果直接写入磁盘。每个spool都可以更改正在写入的文件，因此只需将spool命令放在它们之间，就可以将多个查询写入不同的文件：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1900591|spool+"\path\to\spool1.txt"

select+/*csv*/+*+from+employees;

spool+"\path\to\spool2.txt"

select+/*csv*/+*+from+locations;

spool+off;|code-block|syntax|javascript|1900592|您需要将其作为脚本运行(F5，或SQL工作表上方命令栏上的第二个按钮)。您可能还想探索一些formatting+options和set+command，尽管其中一些没有转换到SQL+Developer中。|1900593|由于您在标题中提到了CSV，我已经包含了一个SQL+Developer-specific+hint，它可以为您进行格式化。|1900594|不过，缺点是SQL+Developer+includes+the+query+in+the+spool+file，您可以将命令和查询放在脚本文件中，然后将其作为脚本运行，从而避免这种情况。|1900595|entityMap|0|LINK|mutability|MUTABLE|url|http://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_twelve043.htm|1|http://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_six.htm|2|http://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_twelve040.htm|3|http://www.thatjeffsmith.com/archive/2012/05/formatting-query-results-to-csv-in-oracle-sql-developer/|4|https://stackoverflow.com/q/19033943/266304^0|5|5|20|5|2N|5|5|D|0|0|0|1S|3|19|I|1|1S|B|2|0|M|R|3|0|K|10|4|0^^$0|@$1|2|3|4|5|6|7|16|8|@$9|17|A|18|B|C]|$9|19|A|1A|B|C]|$9|1B|A|1C|B|C]]|D|@$9|1D|A|1E|1|1F]]|E|$]]|$1|F|3|G|5|H|7|1G|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|1H|8|@$9|1I|A|1J|B|C]]|D|@$9|1K|A|1L|1|1M]|$9|1N|A|1O|1|1P]]|E|$]]|$1|M|3|N|5|6|7|1Q|8|@]|D|@$9|1R|A|1S|1|1T]]|E|$]]|$1|O|3|P|5|6|7|1U|8|@]|D|@$9|1V|A|1W|1|1X]]|E|$]]|$1|Q|3|-4|5|6|7|1Y|8|@]|D|@]|E|$]]]|R|$S|$5|T|U|V|E|$W|X]]|Y|$5|T|U|V|E|$W|Z]]|10|$5|T|U|V|E|$W|11]]|12|$5|T|U|V|E|$W|13]]|14|$5|T|U|V|E|$W|15]]]]

You can use the <a href="http://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_twelve043.htm" rel="noreferrer"><code>spool</code> command</a> (SQL*Plus documentation, but one of many such commands SQL Developer also supports) to write results straight to disk. Each <code>spool</code> can change the file that's being written to, so you can have several queries writing to different files just by putting <code>spool</code> commands between them:

<pre><code>spool "\path\to\spool1.txt"

select /*csv*/ * from employees;

spool "\path\to\spool2.txt"

select /*csv*/ * from locations;

spool off;
</code></pre>

You'd need to run this as a script (F5, or the second button on the command bar above the SQL Worksheet). You might also want to explore some of the <a href="http://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_six.htm" rel="noreferrer">formatting options</a> and the <a href="http://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_twelve040.htm" rel="noreferrer"><code>set</code> command</a>, though some of those do not translate to SQL Developer.

Since you mentioned CSV in the title I've included a <a href="http://www.thatjeffsmith.com/archive/2012/05/formatting-query-results-to-csv-in-oracle-sql-developer/" rel="noreferrer">SQL Developer-specific hint</a> that does that formatting for you.

A downside though is that SQL Developer <a href="https://stackoverflow.com/q/19033943/266304">includes the query in the spool file</a>, which you can avoid by having the commands and queries in a script file that you then run as a script.

blocks|key|1900600|text|在网格中单击，使其具有焦点。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1900601|Ctrl%2BEnd|1900602|这将强制其余的记录回到网格中。|1900603|所有功劳都归于http://www.thatjeffsmith.com/archive/2012/03/how-to-export-sql-developer-query-results-without-re-running-the-query/|offset|length|1900604|entityMap|0|LINK|mutability|MUTABLE|url|http://www.thatjeffsmith.com/archive/2012/03/how-to-export-sql-developer-query-results-without-re-running-the-query/^0|0|0|0|7|38|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@$H|V|I|W|1|X]]|A|$]]|$1|J|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]]]

Click in the grid so it has focus.

Ctrl+End

This will force the rest of the records back into the grid.

All credit to <a href="http://www.thatjeffsmith.com/archive/2012/03/how-to-export-sql-developer-query-results-without-re-running-the-query/" rel="nofollow">http://www.thatjeffsmith.com/archive/2012/03/how-to-export-sql-developer-query-results-without-re-running-the-query/</a>

blocks|key|1687156|text|在Ctrl%2BEnd之后，您可以执行Ctrl%2BA来选择缓冲区中的所有内容，然后粘贴到Ctrl%2BEnd中。Excel甚至将Oracle的每一列放入自己的列中，而不是将整行放入一列中。不错..。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1687157|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

After Ctrl+End, you can do the Ctrl+A to select all in the buffer and then paste into Excel. 
Excel even put each Oracle column into its own column instead of squishing the whole row into one column. Nice..

Using SQL Developer to run queries works good, but I would save a lot of time if I instead of first running the query and then right click the result set and go through the export to csv routine. 

I was wondering whether it is a way in SQL Developer to: 
1) Write the query, and then select that the result of the query should be exported to disk. 
2) Write a queue of several queries, each of them writing their results to disk.

Directly export a query to CSV using SQL Developer

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

使用SQL Developer运行查询效果很好，但如果我不先运行查询，然后右键单击结果集并执行导出到csv例程，则可以节省大量时间。我想知道在SQL Developer中是否有这样一种方式: 1)编写查询，然后选择将查询结果导出到磁盘。2)编写一个由多个查询组成的队列，每个查询将其结果写入磁盘。

问使用SQL Developer直接将查询导出到CSV
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用SQL Developer直接将查询导出到CSVEN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用SQL Developer直接将查询导出到CSV
EN