Solved

Oracle SQL Developer Interface

Posted on 2014-12-10
13
464 Views
Last Modified: 2014-12-11
Hello,
I'm working with queries via the "SQL Developer."  When I do get the results and would like to save them to an Excel file, I can't open the file with the .xlsx, or xls extension.  My options given are .txt, the others, like .java, .class, .sql, I believe not useful for converting to xls.
While I can save a file that the Excel app opens, the format is not separated by rows, columns, and celles.
May be this is more of an Excel question?
0
Comment
Question by:chima
  • 6
  • 3
  • 2
  • +1
13 Comments
 
LVL 29

Assisted Solution

by:leonstryker
leonstryker earned 50 total points
ID: 40491783
Excel can open .txt files or you can save files in CSV format. Excel like those as well.
0
 

Author Comment

by:chima
ID: 40491837
leonstryker, thank you for your reply.  I tried saving it to txt, then copying it from there and into Excel and I get the same format as if I use the .xls extension.  I saved it to WORD and see the paragraph characters.  It just seems like a lot of reformating (see screenshot).  There has to be a better direct way?
Paragraph format
0
 
LVL 29

Expert Comment

by:leonstryker
ID: 40491909
0
 

Author Comment

by:chima
ID: 40491931
Leon, I found the answer an there is a better way.  I'll wait to see if anyone comes up with the answer i have, then I'll issue the points.  Thank you for the help.
0
 
LVL 29

Expert Comment

by:leonstryker
ID: 40491944
If you have a better way, post it. Do not wait for others :)
0
 
LVL 14

Accepted Solution

by:
ThomasMcA2 earned 350 total points
ID: 40491950
Which version of SQL Developer are you using? I have an old version (3.1.07) that can export tables to .xlsx that XL can open fine. Even the Export function from the SQL Worksheet supports .xlsx.
0
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 

Author Comment

by:chima
ID: 40492119
Thomas, can you tell me how.  Then I'll share what I learned.
0
 
LVL 14

Expert Comment

by:ThomasMcA2
ID: 40492168
In a table, above the column headings there is an Actions button. Click that, then select Export.  Or, from a temporary view in the Worksheet, right-click on any row and click Export. Both options bring up the Export dialog where you can pick your export format, such as .xlsx. That exported file opens fine in XL.
0
 
LVL 37

Assisted Solution

by:Gerwin Jansen
Gerwin Jansen earned 100 total points
ID: 40492371
From the result window, select contents (ctrl-a) and paste into an empty Excel sheet and save the Excel file.
0
 

Author Comment

by:chima
ID: 40492731
Thomas, correct.  I do not understand why the "Run Statement (Cntr-Enter) does not give you an output that can be exported to Excel.  Yet the, highlight query, click F9, does produce an output that can be exported.  At least this is how I do it.
0
 

Author Comment

by:chima
ID: 40492736
Gerwin, while your suggestion of doing the copy and paste is similar, I prefer "right click on Export."
0
 
LVL 37

Expert Comment

by:Gerwin Jansen
ID: 40493507
>> of doing the copy and paste is similar
I'm skipping (on purpose) the step in between where you have to choose a file type (like .txt .sql etc). You paste directly into Excel and save.

>> While I can save a file that the Excel app opens, the format is not separated by rows, columns, and celles
But to understand what your issue really is: can you post what result you are getting from the query and post that? Include the query if possible.
0
 

Author Closing Comment

by:chima
ID: 40494279
Thank you, one more question coming
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now