PL/SQL, Oracle's programming language for stored procedures, delivers a world of possibilities for your database programs. PL/SQL supplements the standard relational database language, SQL, with a wide range of procedural features, including loops, IF-THEN statements, advanced data structures, and rich transactional control--all closely integrated with the Oracle database server. Learning Oracle PL/SQL offers the guidance you need to come up to speed on PL/SQL, whether you're a beginner or already experienced with another programming language.Topics include:
PL/SQL - what is it, and why use it?Syntax and examples of all core language constructsCreating and reusing stored procedures, functions, and packagesBuilding web-based applicationsSecuring PL/SQL programs Benefits of third-party developer toolsConnecting PL/SQL to email, Java, and the Internet
Meticulously crafted with all-new, downloadable examples the book includes language features available in all versions from Oracle7 through Oracle9i. Written in an easygoing style by PL/SQL experts Bill Pribyl and Steven Feuerstein, the book delivers a solid foundation for every database developer and administrator who needs to learn PL/SQL.