Oracle PL/SQL Programming

Search my Sites

Custom Search

Part I: Programming in PL/SQL

Chapter 1. Introduction to PL/SQL
Chapter 2. Creating and Running PL/SQL Code
Chapter 3. Language Fundamentals


Part II: PL/SQL Program Structure

Chapter 4. Conditional and Sequential Control
Chapter 5. Iterative Processing with Loops
Chapter 6. Exception Handlers

Part III: PL/SQL Program Data

Chapter 7. Working with Program Data
Chapter 8. Strings
Chapter 9. Numbers
Chapter 10. Dates and Timestamps
Chapter 11. Records
Chapter 12. Collections
Chapter 13. Miscellaneous Datatypes

Part IV: SQL in PL/SQL

Chapter 14. DML and Transaction Management
Chapter 15. Data Retrieval
Chapter 16. Dynamic SQL and Dynamic PL/SQL

Part V: PL/SQL Application Construction

Chapter 17. Procedures, Functions, and Parameters
Chapter 18. Packages
Chapter 19. Triggers
Chapter 20. Managing PL/SQL Code
Chapter 21. I/O and PL/SQL

Part VI: Advanced PL/SQL Topics

Chapter 22. Application Security and PL/SQL
Chapter 23. Inside PL/SQL
Chapter 24. Globalization and Localization in PL/SQL
Chapter 25. Object-Oriented Aspects of PL/SQL
Chapter 26. Calling Java from PL/SQL
Chapter 27. External Procedures


Programming in PL/SQL

This first part of the book introduces PL/SQL, explains how to create and run code, and presents language fundamentals।Chapter 1 asks the fundamental questions: Where did PL/SQL come from? What is it good for?What are the main features of the language?Chapter 2 is designed to get you up and running PL/SQL programs as quickly as possible; it contains clear, straightforward instructions for executing PL/SQL code in SQL*Plus and a few other common environments।Chapter 3 answers basic questions about the language structure and keywords:What makes up a PL/SQL statement? What is the PL/SQL block structure all about? How do I write comments in PL/SQL?



Introduction to PL/SQL

PL/SQL stands for "Procedural Language extensions to the Structured Query Language." SQL is the now-ubiquitous language for both querying and updatingnever mind the nameof relational databases. Oracle Corporation introduced PL/SQL to overcome some limitations in SQL and to provide a more complete programming solution for those who sought to build mission-critical applications to run against the Oracle database. This chapter introduces PL/SQL, its origins, and its various versions. It also offers a guide to additional resources
for PL/SQL developers and some words of advice.