How Do I Write A Cron Which Will Run A SQL Query And Mail The Results To A Group?

RenDC

» Interview Questions and Answers » Questions » News Feed » Tutorials » rendc.com

Question and Answer:

Home Oracle DBA

⟩ How do I write a cron which will run a SQL query and mail the results to a group?

Use DBMS_JOB for scheduling a cron job and DBMS_MAIL to send the results through email.

Is this answer helpful?
0 Yes | 0 No

152 views

More Questions for you:

Explain What is the significance of PAGE 0 in forms 3.0?

Explain What is an Alert?

Explain What SYNCHRONIZE procedure does?

Explain How do we trap the error in forms 3.0 ?

Explain What is the usage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS?

How to execute the user defined triggers in forms 3.0?

Explain What are the types of Pop-up window?

Explain What Enter package procedure does?

Explain What package procedure used for invoke sql *plus from sql *forms?

Explain What is the difference between a POST-FIELD trigger and a POST-CHANGE trigger?

rendc.org

Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."

Quick Links:

Interview Question and Answer Questions Add Questions News-Feed Add Posts HR Hacks Tutorials Profile rendc.com memeph.com

Question and Answer:

Home Oracle DBA

⟩ How do I write a cron which will run a SQL query and mail the results to a group?

Popular Answers:

* There is no answer to the above question yet.

More Questions for you:

Quick Links:

Question and Answer:

Home Oracle DBA

⟩ How do I write a cron which will run a SQL query and mail the results to a group?

Popular Answers:

* There is no answer to the above question yet.

More Questions for you:

BE THE FIRST TO KNOW

Quick Links: