Search my Sites
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
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.
for PL/SQL developers and some words of advice.
No comments:
Post a Comment