How to export query results from Oracle SQL Developer tool
You have run a query against the database in the Oracle SQL Developer tool. Now you want to export the results. This is how you can do it. The screen shows it all. First select all the data the rest is easy.
I've had problems with the most recent version. I'm currently running 1.5.1 Build MAIN-5440 without issue. You may want to revert and see if that makes a difference.
Program pauses for 10 mins (as it often does), then gives me the options to export to file or clipboard. When posting to the clipboard, only one string is shown when pasting it in Excl (java.io.Stringbuffer@)
SQL Developer Data Modeler operates with and models metadata.[4] Prior to SQL Developer version 3, it constituted a separate (but integrated) free[5] counterpart of SQL Developer. As of SQL Developer version 3 modeling has become an integrated part of the overall tool. STC Technologies
Hi I ran a query in sql developer to see some data. Now i want to extract the scripts written for inserting those data. How can i extract those scripts? Reply me on c2swapnil@gmail.com
Excellent tip! Thanks!
ReplyDeleteIt's so obvious... Yet I could not figure out until I found your post via Google.
ReplyDeleteExcellent and very simple. Thank you very much.
ReplyDeleteExcellent and very simple. Thank you very much, you've save me some bandwidth with this tip.
ReplyDeleteI tried it but it doesn't work.
ReplyDeleteI do the following:
execute the query (with F9)
in the results, i click on select all
then I select export data-->XLS but it does nothing
does anyone has the same problem?
I've had problems with the most recent version. I'm currently running 1.5.1 Build MAIN-5440 without issue. You may want to revert and see if that makes a difference.
ReplyDeleteLike suggested by Jayaram Krishnaswamy in a private mail I tried the 1.5.4 and it worked!
ReplyDeleteProgram pauses for 10 mins (as it often does), then gives me the options to export to file or clipboard. When posting to the clipboard, only one string is shown when pasting it in Excl (java.io.Stringbuffer@)
ReplyDeleteKindly check your software version as this may have a bearing. Please read the other related comments.
ReplyDeleteThanks
How do i remove the "" when exporting the results to CSV??
ReplyDeletehow do i remove the "" when exporting the query results to CSV.?
ReplyDeleteSo easy, so obvious, I feel so dummy asking it :)
ReplyDeleteThanks for the tip
FYI, Oracle has now changed this to a terribly named "unload"
ReplyDeleteUnload... Really!!!! I've been ignoring that just because the name.
ReplyDeleteThanks for the information!!!!
Thanks! Saves me the trouble of creating a table with the data first..
ReplyDeleteam having option to zip the export data in Toad . Is any such options are available in SQL developer..
ReplyDeleteSQL Developer Data Modeler operates with and models metadata.[4] Prior to SQL Developer version 3, it constituted a separate (but integrated) free[5] counterpart of SQL Developer. As of SQL Developer version 3 modeling has become an integrated part of the overall tool.
ReplyDeleteSTC Technologies
Hi
ReplyDeleteI ran a query in sql developer to see some data.
Now i want to extract the scripts written for inserting those data.
How can i extract those scripts?
Reply me on c2swapnil@gmail.com
Regards,
Swapnil
If I have multiple query result tabs in sql developer how could I export them all to a single workbook
ReplyDeleteI will try to take a look after downloading the latest version. Right now I am somewhat busy.
ReplyDelete