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 other programming languages. Whether you are a new developer, a crossover programmer from another database system, or a new database administrator who needs to learn PL/SQL, this book will get you well on your way. It is the perfect introduction to Oracle PL/SQL Programming, also by Pribyl and Feuerstein.
Table of contents
- PL/SQL: What, When, and Where
- Let's Code!
- Go Web, Young Man
- Keeping House
- Security: Keep the Bad Guys Out
- Communicating with the Outside World
- Intermediate Topics and Other Diversions
- Afterword: "Making Good" of Database Programming
- Title: Learning Oracle PL/SQL
- Release date: November 2001
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9780596001803
You might also like
Automate the Boring Stuff with Python
Automate the Boring Stuff with Python teaches simple programming skills to automate everyday computer tasks.
Software Engineering at Google
Today, software engineers need to know not only how to program effectively but also how to …
Real World SQL and PL/SQL: Advice from the Experts
Master the Underutilized Advanced Features of SQL and PL/SQL This hands-on guide from Oracle Press shows …
Python Crash Course, 2nd Edition
This is the second edition of the best selling Python book in the world. Python Crash …