Ch. 1. PL/SQL and your database -- Ch. 2. The PL/SQL environment -- Ch. 3. Laying the groundwork : PL/SQL fundamentals -- Ch. 4. Controlling program flow -- Ch. 5. Handling exceptions -- Ch. 6. PL/SQL and SQL working together -- Ch. 7. Putting your code in the right place -- Ch. 8. Creating naming standards -- Ch. 9. Creating coding standards -- Ch. 10. Basic datatypes -- Ch. 11. Advanced datatypes -- Ch. 12. Transaction control -- Ch. 13. Dynamic SQL and PL/SQL -- Ch. 14. PL/SQL best practices -- Ch. 15. Ten PL/SQL tips -- Ch. 16. Ten common mistakes to avoid in PL/SQL.
0
Find tips for creating efficient PL/SQL code If you know a bit about SQL, this book will make PL/SQL programming painless! The Oracle has spoken-you need to get up to speed on PL/SQL programming, right? We predict it'll be a breeze with this book! You'll find out about code structures, best practices, and code naming standards, how to use conditions and loops, where to place PL/SQL code in system projects, ways to manipulate data, and more. Discover how toWrite efficient, easy-to-maintain codeTest and debug PL/SQL routinesIntegrate SQL and PL/SQLApply PL/SQL best practicesUse new features introduced in Oracle 9i and 10g.