开发者

How to export data with Oracle SQL Developer?

开发者 https://www.devze.com 2022-12-25 09:57 出处:网络
How to export Oracle DB data开发者_运维问答 using SQL Developer? I need all data, tables, constraints, structure and so on.In SQL Developer, from the top menu choose Tools > Data Export.This launches

How to export Oracle DB data开发者_运维问答 using SQL Developer? I need all data, tables, constraints, structure and so on.


In SQL Developer, from the top menu choose Tools > Data Export. This launches the Data Export wizard. It's pretty straightforward from there.

There is a tutorial on the OTN site. Find it here.


In version 3, they changed "export" to "unload". It still functions more or less the same.


If, at some point, you only need to export a single result set, just right click "on the data" (any column of any row) there you will find an export option. The wizard exports the complete result set regardless of what you selected


To export data you need to right click on your results and select export data, after which you will be asked for a specific file format such as insert, loader, or text etc. After selecting this browse your directory and select the export destination.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号