Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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.

like image 617
Shahin P Avatar asked Oct 21 '25 08:10

Shahin P


1 Answers

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).

like image 111
Alexei Martianov Avatar answered Oct 23 '25 06:10

Alexei Martianov