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? Category SQL Interview Questions Rating (0.4) By 351 users Added on 7/25/2006 Views 3179 Rate it! * * * * * * * * * * * * * * *

Answers: Use DBMS_JOB for scheduling a cron job and DBMS_MAIL to send the results throught email. 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. Name :* Email Id :* Answer :* Verification Code Not readable? Load New Code   Enter the above shown code:* Inform me about updated answers to this question

	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"?	View Answer
	What is the difference between SQL and SQL Server?	View Answer

Please Note: We keep on updating better answers to this site. Subscribe to our newsletter to get notified when better answer is posted.

Notify me when better answer is posted!
Email: