想要从oracle SQL开发人员工具中提取/导出1,766,048条记录 [英] Want to extract/export 1, 766, 048 records from oracle SQL developer tools

问题描述

Hi All,

I Want to extract 1,766,048 records into any file extension like (.xls,.xlsx,.csv) from Oracle SQL Developer tools.

Is there any specific keywords which can be used with select query while extracting data like (Limit, range..! Any other techniques?) through which i can extract data in section wise.

Note: I'm using select statement to fetch data from multiple tables using Oracle SQL Developer tools.


Please suggest and guide me as soon as possible, i need all records and data is important.

我尝试了什么：



我使用过limit关键字。

并且无法找到任何解决方案。

What I have tried:

i've used limit keyword.
and not able to found any solutions.

推荐答案

确保使用运行语句选项（Ctrl + Enter）运行语句。然后在查询结果网格中单击任何单元格，然后按Ctrl + End，这将获取所有记录。



导出右键单击查询结果网格并选择导出和其中一种格式选项是Excel。

Make sure you run your statement with the Run Statement option (Ctrl + Enter). Then in the query results grid click any cell and then press Ctrl + End and that will fetch all records.

To export just right click in the query results grid and select Export and one of the format options is Excel.

这篇关于想要从oracle SQL开发人员工具中提取/导出1,766,048条记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！