Considered the best Oracle PL/SQL programming guide by the Oracle community. Steven Feuerstein, Bill PribylSteven Feuerstein. Oracle PL/SQL Programming. Oracle PL/SQL Programming - Bill Pribyl, Steven Feuerstein. FOURTH EDITIONOracle PL/SQL Programming. Steven Feuersteinwith Bill Pribyl. Beijing . On- line editions are also available for most titles (safari. Steven Feuerstein, Bill Pribyl 'O'Reilly Media, Inc.'. Oracle PL/SQL Programming : Considered the best Oracle PL/SQL programming guide by the Oracle community. Oracle PL/SQL Programming . Steven Feuerstein, Bill Pribyl, Chip Dawes. A companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL. Oracle PL/SQL Programming. Oracle PL/SQL Language Pocket Reference, by Steven Feuerstein, Bill Pribyl, and. Steven Feuerstein's Oracle PL/SQL Programming site. The definitive reference on PL/SQL, Oracle PL/SQL Programming. By Steven Feuerstein, Bill Pribyl. This is a great book to prepare for the Oracle PL/SQL. For more information, contact our cor- porate/institutional sales department: (8. Editor: Deborah Russell. Production Editor: Mary Anne Weeks Mayo. Cover Designer: Edie Freedman. Interior Designer: David Futato. Printing History: September 1. First Edition. September 1. Second Edition. September 2. Third Edition. August 2. Fourth Edition. Nutshell Handbook, the Nutshell Handbook logo, and the O’Reilly logo are registered trademarks of. O’Reilly Media, Inc. Oracle PL/SQL Programming, Fourth Edition, the image of ants, and related tradedress are trademarks of O’Reilly Media, Inc. Many of the designations used by manufacturers and sellersto distinguish their products are claimed as trademarks. Where those designations appear in this book,and O’Reilly Media Inc., was aware of a trademark claim, the designations have been printed in caps orinitial caps. O’Reilly Media, Inc., is independent of. Java and all Java- based trademarks and logos are trademarks or registeredtrademarks of Sun Microsystems, Inc., in the United States and other countries. O’Reilly Media, Inc., is. Microsoft , Windows , and all Microsoft- based trademarksand logos are trademarks or registered trademarks of Microsoft, Inc., in the United States and othercountries. Programming in PL/SQL1. Introduction to PL/SQL . The Origins of PL/SQL 4. So This Is PL/SQL 7. About PL/SQL Versions 1. Resources for PL/SQL Developers 1. Some Words of Advice 2. Creating and Running PL/SQL Code . SQL*Plus 2. 5Performing Essential PL/SQL Tasks 4. Calling PL/SQL from Other Languages 4. Language Fundamentals . PL/SQL Block Structure 5. The PL/SQL Character Set 6. Identifiers 6. 6Literals 7. The Semicolon Delimiter 7. Comments 7. 5The PRAGMA Keyword 7. Labels 7. 8v. Part II. PL/SQL Program Structure. Conditional and Sequential Control . IF Statements 8. 3CASE Statements and Expressions 9. The GOTO Statement 1. The NULL Statement 1. Iterative Processing with Loops . Considered the best Oracle PL/SQL programming guide by the Oracle community. Oracle PL/SQL Programming eBook: Steven Feuerstein, Bill Pribyl: Amazon.com.au: Kindle Store Amazon.com.au. Oracle PL/SQL Programming. Steven Feuerstein, Bill Pribyl. The definitive reference on PL/SQL, Oracle PL/SQL Programming, Fifth Edition. Buy, download and read Oracle PL/SQL Programming ebook online in EPUB or PDF format for iPhone, iPad, Android, Computer and Mobile readers. Author: Steven Feuerstein. Loop Basics 1. 05. The Simple Loop 1. The WHILE Loop 1. The Numeric FOR Loop 1. The Cursor FOR Loop 1. Loop Labels 1. 19. Tips for Iterative Processing 1. Exception- Handling Concepts and Terminology 1. Defining Exceptions 1. Raising Exceptions 1. Handling Exceptions 1. Building an Effective Error Management Architecture 1. Making the Most of PL/SQL Error Management 1. Part III. Working with Program Data . Naming Your Program Data 1. Overview of PL/SQL Datatypes 1. Declaring Program Data 1. Programmer- Defined Subtypes 1. Conversion Between Datatypes 1. String Datatypes 1. Working with Strings 1. String Function Quick Reference 2. Numeric Datatypes 2. Number Conversions 2. Numeric Functions 2. Dates and Timestamps . Datetime Datatypes 2. Getting the Date and Time 2. Interval Datatypes 2. Datetime Conversions 2. Date and Timestamp Literals 2. Interval Conversions 2. Interval Literals 2. CAST and EXTRACT 2. Datetime Arithmetic 2. Date/Time Functions 2. Records in PL/SQL 3. Collections Overview 3. Collection Methods (Built- Ins) 3. Working with Collections 3. Nested Table Multiset Operations 3. Maintaining Schema- Level Collections 3. Miscellaneous Datatypes . The BOOLEAN Datatype 3. The RAW Datatype 3. The UROWID and ROWID Datatypes 3. The LOB Datatypes 3. Working with LOBs 3. Predefined Object Types 4. Table of Contents . DML and Transaction Management . DML in PL/SQL 4. 26. Bulk DML with the FORALL Statement 4. Transaction Management 4. Autonomous Transactions 4. Cursor Basics 4. 61. Working with Implicit Cursors 4. Working with Explicit Cursors 4. BULK COLLECT 4. 91. SELECT.. FOR UPDATE 4. Cursor Variables and REF CURSORs 5. Cursor Expressions 5. Dynamic SQL and Dynamic PL/SQL . NDS Statements 5. Binding Variables 5. Working with Objects and Collections 5. Dynamic PL/SQL 5. Recommendations for NDS 5. When to Use DBMS. PL/SQL Application Construction. Procedures, Functions, and Parameters . Modular Code 5. 66. Procedures 5. 67. Functions 5. 71. Parameters 5. Local Modules 5. 91. Module Overloading 5. Forward Declarations 6. Advanced Topics 6. Go Forth and Modularize! Rules for Building Packages 6. Rules for Calling Packaged Elements 6. Working with Package Data 6. When to Use Packages 6. Packages and Object Types 6. DML Triggers 6. 56. DDL Triggers 6. 73. Database Event Triggers 6. INSTEAD OF Triggers 6. AFTER SUSPEND Triggers 6. Maintaining Triggers 7. Managing PL/SQL Code . Managing Code in the Database 7. Using Native Compilation 7. Using the Optimizing Compiler and Compile- Time Warnings 7. Conditional Compilation 7. Testing PL/SQL Programs 7. Debugging PL/SQL Programs 7. Tuning PL/SQL Programs 7. Protecting Stored Code 7. Displaying Information 7. Reading and Writing Files 7. Sending Email 7. 96. Working with Web- Based Data (HTTP) 8. Other Types of I/O Available in PL/SQL 8. Part VI. Advanced PL/SQL Topics. Application Security and PL/SQL . Security Overview 8. Encryption 8. 25. Table of Contents . Looking Under the Hood 8. PL/SQL’s Optimizing Compiler 8. Dependency Management 8. Execution Authority Models 9. PL/SQL and Oracle Memory 9. Server- Side PL/SQL Processing: Reprise 9. What You Need to Know 9. Globalization and Localization in PL/SQL . Overview and Terminology 9. Unicode Primer 9. Character Semantics 9. String Sort Order 9. Multilingual Information Retrieval 9. Date/Time 9. 67. Currency Conversion 9. Globalization Development Kit for PL/SQL 9. Object- Oriented Aspects of PL/SQL . Introduction to Oracle’s Object Features 9. An Extended Example 9. Object Views 1. 02. Maintaining Object Types and Object Views 1. Pontifications 1. Calling Java from PL/SQL . Oracle and Java 1. Getting Ready to Use Java in Oracle 1. A Simple Demonstration 1. Using loadjava 1. Using dropjava 1. Managing Java in the Database 1. Using DBMS. 1. 07. Introduction to External Procedures 1. The Oracle Net Configuration 1. Setting Up Multithreaded Mode 1. Creating an Oracle Library 1. Writing the Call Specification 1. Raising an Exception from the Called C Program 1. Nondefault Agents 1. Maintaining External Procedures 1. A. Regular Expression Metacharacters and Function Parameters . Number Format Models . Table of Contents . At the heart of much of Oracle’s software is PL/SQL—a program- ming 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 productreleased by Oracle Corporation. Software professionals use PL/SQL to perform manykinds of programming functions, including. Ada is a high- level language that emphasizes data abstrac- tion, information hiding, and other key elements of modern design strategies. As aresult of this very smart design decision by Oracle, PL/SQL is a powerful languagethat incorporates many of the most advanced elements of procedural languages,including. For more information about Ada, visit http: //www. This is the Title of the Book, e. Matter Editiontions (which are Oracle’s version of arrays), and XMLType (for managing XMLdocuments in Oracle and through PL/SQL). Conversely, you can also callyour own PL/SQL functions from within a SQL statement. Oracle developers who want to be successful in the 2. PL/SQL to full advantage. This is a two- step process. First, you must become famil- iar with and learn how to use the language’s ever- expanding set of features; and sec- ond, after gaining competence in the individual features, you must learn how to putthese constructs together to build complex applications. For these reasons and more, Oracle developers need a solid, comprehensive resourcefor the base PL/SQL language. You need to know the basic building blocks of PL/SQL,but you also need to learn by example so that you can avoid some of the trial and error. As with any programming language, PL/SQL has a right way and many wrong ways (orat least “not as right” ways) to handle just about any task. It is our hope that this bookwill help you learn how to use the PL/SQL language in the most effective and efficientway possible. Objectives of This Book. What, specifically, will this book help you do? Take full advantage of PL/SQLOracle’s reference manuals may describe all the features of the PL/SQL lan- guage, but they don’t tell you how to apply the technology. In fact, in somecases, you’ll be lucky to even understand how to use a given feature after you’vemade your way through the railroad diagrams. Books and training courses tendto cover the same standard topics in the same limited way. In this book, we’llventure beyond the basics to the far reaches of the language, finding the non- standard ways that a particular feature can be tweaked to achieve a desiredresult. You use PL/ SQL to solve problems for yourcompany or your customers. In this book, we try hard to help you tackle real- world problems, the kinds of issues developers face on a daily basis (at leastthose problems that can be solved with mere software). To do this, we’ve packedthe book with examples—not just small code fragments, but substantial applica- tion components that you can apply immediately to your own situations. Thereis a good deal of code in the book itself, and much more on the accompanyingweb site. In a number of cases, we use the code examples to guide you throughthe analytical process needed to come up with a solution. In this way you’ll see,in the most concrete terms, how to apply PL/SQL features and undocumentedapplications of those features to a particular situation. Write efficient, maintainable code. PL/SQL and the rest of the Oracle products offer the potential for incredibledevelopment productivity. If you aren’t careful, however, this capability will sim- ply let you dig yourself into a deeper, darker hole than you’ve ever found your- self in before.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2016
Categories |