使用SQL-Developer时脚本输出到文件 [英] Script output to file when using SQL-Developer

问题描述

我有一个select查询产生了一个很大的输出，我想在sqldeveloper中执行它，并将所有结果保存到一个文件中.

I have a select query producing a big output and I want to execute it in sqldeveloper, and get all the results into a file.

Sql-developer不允许结果大于5000行，而我有10万行要提取...

Sql-developer does not allow a result bigger than 5000 lines, and I have 100 000 lines to fetch...

我知道我可以使用SQL +，但是假设我想在sqldeveloper中这样做.

I know i could use SQL+, but let's assume I want to do this in sqldeveloper.

推荐答案

代替使用运行脚本(F5)，而使用运行语句(Ctrl + Enter).运行语句一次获取50条记录并在滚动结果时显示它们...但是您可以通过右键单击结果并选择导出数据-> csv/html/将全部输出保存到文件中等等.

Instead of using Run Script (F5), use Run Statement (Ctrl+Enter). Run Statement fetches 50 records at a time and displays them as you scroll through the results...but you can save the entire output to a file by right-clicking over the results and selecting Export Data -> csv/html/etc.

我是SQLDeveloper的新手用户，所以如果有更好的方法，请告诉我.

I'm a newbie SQLDeveloper user, so if there is a better way please let me know.

这篇关于使用SQL-Developer时脚本输出到文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！