Beginning Oracle PL/SQL


File Size: 3.98 Mb

Description
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 this? 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.

Content:-
About the Author
About the Technical Reviewer
Acknowledgments
Foreword
Introduction (The Big Picture)
Chapter 1: Relational SQL
Chapter 2: Blocks, Functions, and Procedures
Chapter 3: Types, Variables, and Scope
Chapter 4: Single Row Processing
Chapter 5: Multirow Processing
Chapter 6: Object-Relational SQL
Chapter 7: Troubleshooting
Chapter 8: Testing
Chapter 9: Documenting
Chapter 10: Examples
Appendix A: How to Download, Install, and Use Oracle
Index

Author Details
"Donald Bales" is a computer applications consultant specializing in the analysis, design, and programming of client-server and web-based distributed systems, systems integration, and data warehousing. Don has over 20 years of experience with Oracle as both a developer and a database administrator, and 10 years of experience with Java.




Download Drive-1

You May Also Like These E-Books:-

No comments:

Post a Comment