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 throught email.

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

DATABASE

SQL

DETAILS

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

Answer: Use DBMS_JOB for scheduling a cron job and DBMS_MAIL to send the results throught email.

Category	SQL Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 6742 users
Added on	7/25/2011
Views	70983
Rate it!

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

Answer:

Use DBMS_JOB for scheduling a cron job and DBMS_MAIL to send the results throught email. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	Is there any query which is used to find the case sensitivity in each records in database through visual basic?	View Answer
	I have a table with duplicate names in it. Write me a query which returns only duplicate rows with number of times they are repeated.	View Answer
	How to copy sql table.	View Answer
	Difference between Store Procedure and Trigger	View Answer
	Cursor Syntax brief history	View Answer
	Explain normalization with examples.	View Answer
	How to find out the database name from SQL*PLUS command prompt?	View Answer
	How can we backup the sql files & what is SAP?	View Answer
	Whats the back end processes when we type "Select * from Table"?	- SQL Interview Questions & Answers"> View Answer
	What is the difference between SQL and SQL Server?	View Answer
	What is table space	View Answer
	What is diffrence between Co-related sub query and nested sub query??	View Answer
	There is a eno & gender in a table. Eno has primary key and gender has a check constraints for the values 'M' and 'F'. While inserting the data into the table M was misspelled as F and F as M. What is the update statement to replace F with M and M with F?	View Answer
	When we give SELECT * FROM EMP; How does oracle respond:	View Answer
	What is reference cursor ?	View Answer
	What operators performs pattern matching?	View Answer
	There are 2 tables, Employee and Department. There are few records in employee table, for which, the department is not assigned. The output of the query should contain all th employees names and their corresponding departments, if the department is assigned otherwise employee names and null value in the place department name. What is the query?	View Answer
	What is difference between Oracle and MS Access? What are disadvantages in Oracle and MS Access? What are features & advantages in Oracle and MS Access?	View Answer
	Can we call user defined packages in SQL statements?	View Answer
	What is normalization,types with eg's. _ with queries of all types?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All SQL Interview Questions & Answers - Exam Mode / Learning Mode