Solved

Oracle SQL Developer Interface

Posted on 2014-12-10
13
473 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 

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
 

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 38

Assisted Solution

by:Gerwin Jansen, EE MVE
Gerwin Jansen, EE MVE 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 38

Expert Comment

by:Gerwin Jansen, EE MVE
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

734 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