Skip to Main Content
  • Questions

  • How to automate report generation from Oracle sql developer.

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, sharanya.

Asked: August 03, 2016 - 2:35 pm UTC

Last updated: August 09, 2016 - 1:16 pm UTC

Version: Oracle SQL Developer 4.1.3

Viewed 10K+ times! This question is

You Asked

Can I automate the report generation and schedule it to my end customers from SQL developer?

I have an SQL query which gives me some amount of data, I want to generate a report(may be CSV) with that sql query and I need to schedule that report to my end customers. Can I generate and schedule a report directly from SQL Developer?


Right now, I am writing a Java program to connect to db and generating a csv file from java.


and Chris said...

Well SQL Developer reports do have a command line interface. So you probably could build something to call this and email the reports. It's not the best method though!

You could build a PL/SQL procedure that generates the data you need. Then emails using UTL_MAIL:

https://oracle-base.com/articles/10g/plsql-enhancements-10g#UTL_MAIL
https://oracle-base.com/articles/misc/email-from-oracle-plsql

But if you need user input this could be fiddly. Or you could use interactive reports in APEX. These allow users to subscribe to whichever reports they want!

http://www.talkapex.com/2010/09/apex-ir-subscriptions-with-bind.html
https://docs.oracle.com/database/121/AEEUG/int_rpt.htm#AEEUG490

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

sharanya, August 09, 2016 - 2:12 pm UTC


more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library