CODEWITHSUNDEEP
exceloracle-databaseoracle-sqldeveloper
Shahin P
Shahin P

Reputation: 367

how to copy the records from output of oracle SQL developer to excel sheet

I got some records from Oracle SQL developer & in the output query result. I want to copy the data & paste into the Excel sheet. How to copy the records from output of oracle SQL developer to Excel sheet.

Upvotes: 4

Views: 24878

Answers (4)

Avijit Nagare
Avijit Nagare

Reputation: 8802

  1. Select All in Query result section -> Right click and click on "Export..."
  2. Select format as "excel 95-2003 (xls).
  3. Change location where you want save excel dump file. Ex. C:\ from "Browse"
  4. Click "Next" and "Finish" in export summary section.

enter image description here

Upvotes: 1

Guest
Guest

Reputation: 11

Click on a cell in the output query results column and then press Ctrl + A to select all the records from the output query results. Then, press Shift+Ctrl+C to copy all the data and now go to your excel sheet and paste it.

Upvotes: 1

Alex Martian
Alex Martian

Reputation: 3812

As I understand, accepted answer will get you results w/out headers. You can use right-click on results -> export there use clipboard as save-as, format -> delimited and the trick - delimiter to TAB (at least with tab paste works properly for my Excel version, default comma does not).

Upvotes: 6

Md Wasi
Md Wasi

Reputation: 503

It's simple, select all the records from the output query result and copied it by using Ctrl+C then after open new DataBase File on top left side of the Oracle SQL developer. Then after paste all the data there into that DataBase File. Again copied the data from that DataBase files using Ctrl+C & paste it into the Excel Sheet.

Upvotes: 4

Related Questions