Oracle PL/SQL Programming


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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s