• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 497
  • Last Modified:

Oracle SQL Developer Interface

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
chima
Asked:
chima
  • 6
  • 3
  • 2
  • +1
3 Solutions
 
leonstrykerCommented:
Excel can open .txt files or you can save files in CSV format. Excel like those as well.
0
 
chimaAuthor Commented:
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
 
leonstrykerCommented:
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

 
chimaAuthor Commented:
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
 
leonstrykerCommented:
If you have a better way, post it. Do not wait for others :)
0
 
ThomasMcA2Commented:
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
 
chimaAuthor Commented:
Thomas, can you tell me how.  Then I'll share what I learned.
0
 
ThomasMcA2Commented:
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
 
Gerwin Jansen, EE MVETopic Advisor Commented:
From the result window, select contents (ctrl-a) and paste into an empty Excel sheet and save the Excel file.
0
 
chimaAuthor Commented:
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
 
chimaAuthor Commented:
Gerwin, while your suggestion of doing the copy and paste is similar, I prefer "right click on Export."
0
 
Gerwin Jansen, EE MVETopic Advisor Commented:
>> 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
 
chimaAuthor Commented:
Thank you, one more question coming
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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.

  • 6
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now