Learning Oracle PL/SQL

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. Knowing where to start with Oracle's procedural language is not always obvious to a newcomer, especially considering the language's feature set and the sheer size of the official documentation (not to mention Oracle's ever-increasing number of pre-built Pl/Sql programs). But Learning Oracle Pl/Sql offers the signposts and guidance you need to come up to speed on the language, delivered in a manageable number of pages while covering all the essentials. Topics include: Pl/Sql-what is it, and why use it? Why use Pl/Sql instead of Java? Syntax and examples of all core language constructs Creating, using, and reusing stored procedures, functions, and packages Building web-based applications using Pl/Sql features available "out of the box" (such as Pl/Sql Server Pages) Securing Pl/Sql programs against attack Benefits of third-party developer tools and integrated development environments Connecting Pl/Sql to email, Java, and the Internet Meticulously crafted with all-new examples downloadable from examples.oreilly.com/learnoracle, the book addresses language features available in all versions of Oracle, from Oracle7 to Oracle8i to Oracle9i. Learning Oracle Pl/Sql was written by Pl/Sql experts Bill Pribyl and Steven Feuerstein, whose easy-to-read style and attention to detail has made other O'Reilly books (such as the bestselling Oracle Pl/Sql Programming ) very popular among Oracle developers worldwide. Learning Oracle Pl/Sql is meant for a wide range of target audiences, including both beginning programmers and those already experienced with ot