This is a book about writing stored procedures for an Oracle database. A stored procedure in this context is a generic term for a program written in the Procedure Language extension for SQL (PL/SQL) that is stored inside the database when it is compiled. This means that you can then execute the program from inside the database. Why would you want to do that? Because your program will run faster inside the database.
Let’s slow down for a minute, so I can explain what a stored procedure is and why you would want to use one.\
DONALD J. BALES is a business analyst and computer applications consultant specializing in the analysis, design, and programming of client-server and web-based distributed applications, internationalization of existing applications, systems integration, and data warehousing. Don has more than 20 years of experience with Oracle, as both a developer and a database administrator, and over ten years of experience with Java. He is currently working on the infrastructure of a spatial database for a major geographic information system (GIS) vendor. When he is not developing applications, Don can often be found working with horses, playing the piano, or playing the bagpipes. Don has had several careers, at various times serving as a mechanic, a general contractor, Mr. Mom, a developer, a chief technical officer, and currently, a consultant. He has a Bachelor of Science degree in Business from Elmhurst College in Elmhurst, Illinois. Don currently resides in Downers Grove, Illinois, with his wife Diane and his daughter Kristyn. He can be contacted by email at email@example.com.