Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

query results to HTML table

user10936714Oct 22 2013 — edited Oct 23 2013

I'm looking for a more efficient way to convert a query result into an HTML table so that I can paste it into an email. The procedure in sqldeveloper (version 3.1.07) is just too clunky and involves too many keystrokes and mouse clicks. And you can't save the HTML to the clipboard. (I'm talking about the "Export..." action here.)

Am I missing something? Are there any alternatives?

Thanks!

Comments

TSharma-0racle

I didn't understand the question clearly but will this work for yo?

SET MARKUP HTML ON

spool on

query

spool off

This will generate a html report from sqlplus

1 person found this helpful
user10936714

This is helpful, but the main problem is to get the HTML into the clipboard with MIME type "text/html" so that when you paste it the email client knows that it is HTML instead of just text. My experience with sqlplus is that it is just a command-line/console app.

1 person found this helpful
TSharma-0racle

Check this if this can help:

Converting Query results into HTML email

SchemaCzar

+1 to this as a feature request

  1. copy as html to clipboard
  2. FEWER CLICKS when exporting from query result!
  3. some controls over html template/styles
  4. Create html email from query result
SchemaCzar

I've had good luck with the html markup, but sqlplus is so last millenium....

Marwim 
... but sqlplus is so last millenium....

Seriously? I'm from the last millennium too, nevertheless I don't consider myself out of date

SQL*PLUS is still my first choice when I have to run a script. I'ts behaviour is reliably the same whereever my script is executed. I would never trust a script that needs another tool to be executed.

Generating a HTML-mail is IMHO out of scope for a database tool. It's a feature I would expect in a BI tool that specializes on reporting.

Regards

Marcus

1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 20 2013
Added on Oct 22 2013
#export, #html, #sql-developer, #sqldeveloper
6 comments
3,583 views