ABSTRACT
This chapter is for advanced users. A user can save a query in a stored procedure and schedule a task to run the job automatically. Many organizations are using stored procedures to do all kinds of tasks during non-business hour. For example, stored procedures can be used to generate daily, weekly, and monthly sales reports.
Oracle, SQL Server and MySQL stored procedures are discussed in this chapter. Three different styles are compared through detailed examples. By the end of the chapter readers will be able to create and run stored procedures in Oracle, SQL Server and MySQL databases.
