Free Download Oracle PL/SQL Programming, 6th Edition in PDF written by Steven Feuerstein & Bill Pribyl and published by O’Reilly Media, Inc.
According to the Authors, “Millions of application developers and database administrators around the world use software provided by Oracle Corporation to build complex systems that manage vast quantities of data. At the heart of much of Oracle’s software is PL/SQL—a programming language that provides procedural extensions to Oracle’s version of SQL (Structured Query Language) and serves as the programming language within the Oracle Developer toolset (most notably Forms Developer and Reports Developer).
PL/SQL figures prominently as an enabling technology in almost every new product released by Oracle Corporation. Software professionals use PL/SQL to perform many kinds of programming functions, including:
- Implementing crucial business rules in the Oracle Server with PL/SQL-based stored procedures and database triggers
- Generating and managing XML documents entirely within the database
- Linking web pages to an Oracle database
- Implementing and automating database administration tasks—from establishing row-level security to managing rollback segments within PL/SQL programs
PL/SQL was modeled after Ada,1 a programming language designed for the US Department of Defense. Ada is a high-level language that emphasizes data abstraction, information hiding, and other key elements of modern design strategies. As a result of this very smart design decision by Oracle, PL/SQL is a powerful language that incorporates many of the most advanced elements of procedural languages.
Oracle developers who want to be successful in the 21st century must learn to use PL/SQL to full advantage. This is a two-step process. First, you must become familiar with and learn how to use the language’s ever-expanding set of features; and second, after gaining competence in the individual features, you must learn how to put these constructs together to build complex applications.
Table of Contents
- Introduction to PL/SQL
- Creating and Running PL/SQL Code
- Language Fundamentals
- Conditional and Sequential Control
- Iterative Processing with Loops
- Exception Handlers
- Working with Program Data
- Strings
- Numbers
- Dates and Timestamps
- Records
- Collections
- Miscellaneous Datatypes
- DML and Transaction Management
- Data Retrieval
- Dynamic SQL and Dynamic PL/SQL
- Procedures, Functions, and Parameters
- Packages
- Triggers
- Managing PL/SQL Code
- Optimizing PL/SQL Performance
- I/O and PL/SQL
- Application Security and PL/SQL
- PL/SQL Architecture
- Globalization and Localization in PL/SQL
- Object-Oriented Aspects of PL/SQL
- Calling Java from PL/SQL
- External Procedures
Free Download Oracle PL/SQL Programming, 6th Edition in PDF from following download links.
File Size: 6.84 MB Pages: 306 Please Read Disclaimer
Don’t forget to drop a comment below after downloading this book.
Note: If download links are not working, kindly drop a comment below, so we’ll update the download link for you.
You may also like to download Databases: A Beginners Guide in PDF