skip to content
Oracle PL/SQL programming Preview this item
ClosePreview this item
Checking...

Oracle PL/SQL programming

Author: Steven Feuerstein
Publisher: Sebastopol, CA : O'Reilly & Associates, 1997.
Edition/Format:   Book : English : 2nd edView all editions and formats
Database:WorldCat
Summary:
"Oracle8 presents PL/SQL programmers with new challenges by increasing both the possibilities and the complexities of the language. This new edition updates the original book for Oracle8, adding chapters describing the new PL/SQL object features (object types, collections, object views and external procedures). The second edition also contains a much-requested chapter on tuning PL/SQL, as well as expanded  Read more...
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

 

Find a copy online

Links to this item

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Additional Physical Format: Online version:
Feuerstein, Steven.
Oracle PL/SQL programming.
Sebastopol, CA : O'Reilly & Associates, 1997
(OCoLC)698019011
Material Type: Internet resource
Document Type: Book, Internet Resource
All Authors / Contributors: Steven Feuerstein
ISBN: 1565923359 9781565923355
OCLC Number: 37741266
Notes: Includes index.
Description: xxxiii, 987 p. : ill. ; 24 cm. + 1 computer disk (3 1/2 in.)
Contents: Foreword Preface I. Programming in PL/SQL 1. Introduction to PL/SQL What Is PL/SQL? The Concept of Programming in Oracle Applications The Origins of PL/SQL PL/SQL Versions Advice for Oracle Programmers A Few of My Favorite (PL/SQL) Things Best Practices for PL/SQL Excellence 2. PL/SQL Language Fundamentals The PL/SQL Character Set Identifiers Literals The Semicolon Delimiter Comments The PRAGMA Keyword Block Structure 3. Effective Coding Style Fundamentals of Effective Layout Formatting SQL Statements Formatting Control Structures Formatting PL/SQL Blocks Formatting Packages Using Comments Effectively Documenting the Entire Package II. PL/SQL Language Elements 4. Variables and Program Data Identifiers Scalar Datatypes NULLs in PL/SQL Variable Declarations Anchored Declarations Programmer-Defined Subtypes Tips for Creating and Using Variables 5. Conditional and Sequential Control Conditional Control Statements Sequential Control Statements 6. Database Interaction and Cursors Transaction Management Cursors in PL/SQL Implicit and Explicit Cursors Declaring Cursors Opening Cursors Fetching from Cursors Column Aliases in Cursors Closing Cursors Cursor Attributes Cursor Parameters SELECT FOR UPDATE in Cursors Cursor Variables Working with Cursors 7. Loops Loop Basics The Simple Loop The Numeric FOR Loop The Cursor FOR Loop The WHILE Loop Managing Loop Execution Tips for PL/SQL Loops 8. Exception Handlers Why Exception Handling? The Exception Section Types of Exceptions Determining Exception-Handling Behavior Raising an Exception Handling Exceptions Client-Server Error Communication NO_DATA_FOUND: Multipurpose Exception Exception Handler as IF Statement RAISE Nothing but Exceptions 9. Records in PL/SQL Record Basics Table-Based Records Cursor-Based Records Programmer-Defined Records Assigning Values to and from Records Record Types and Record Compatibility Nested Records 10. PL/SQL Tables PL/SQL Tables and Other Collections Characteristics of PL/SQL Tables PL/SQL Tables and DML Statements Declaring a PL/SQL Table Referencing and Modifying PL/SQL Table Rows Filling the Rows of a PL/SQL Table Clearing the PL/SQL Table PL/SQL Table Enhancements in PL/SQL Release 2.3 Working with PL/SQL Tables III. Built-In Functions 11. Character Functions Character Function Descriptions Character Function Examples 12. Date Functions Date Function Descriptions Date Function Examples 13. Numeric, LOB, and Miscellaneous Functions Numeric Function Descriptions LOB Function Descriptions Miscellaneous Function Descriptions 14. Conversion Functions Conversion Formats Conversion Function Descriptions Conversion Function Examples IV. Modular Code 15. Procedures and Functions Modular Code Review of PL/SQL Block Structure The Anonymous PL/SQL Block Procedures Functions Parameters Local Modules Module Overloading Forward Declarations Go Forth and Modularize! 16. Packages The Benefits of Packages Overview of Package Structure The Package Specification The Package Body Package Data Package Initialization 17. Calling PL/SQL Functions in SQL Looking at the Problem Syntax for Calling Stored Functions inSQL Requirements for Stored Functions inSQL Restrictions on PL/SQL Functions in SQL Calling Packaged Functions in SQL Column/Function Name Precedence Realities: Calling PL/SQL Functions in SQL Examples of Embedded PL/SQL V. New PL/SQL8 Features 18. Object Types Introduction to Oracle8 Objects Oracle Objects Example Syntax for Creating Object Types Manipulating Objects in PL/SQL and SQL Modifying Persistent Objects Object Housekeeping Making the Objects Option Work 19. Nested Tables and VARRAYs Types of Collections Creating the New Collections Syntax for Declaring Collection Datatypes Using Collections Collection Pseudo-Functions Collection Built-Ins Example: PL/SQL-to-Server Integration Collections Housekeeping Which Collection Type Should I Use? 20. Object Views Example: Using Object Views INSTEAD OF Triggers Syntax for Object Views Differences Between Object Views and Object Tables Not All Views with Objects Are Object Views Schema Evolution Object Views Housekeeping Postscript: Using the BFILE Datatype 21. External Procedures Introduction to External Procedures Steps in Creating an External Procedure Syntax for External Procedures Mapping Parameters OCI Service Routines External Procedure Housekeeping Examples VI. Making PL/SQL Programs Work 22. Code Design Tips Select Meaningful Module and Parameter Names Build the Most Functional Functions Take Full Advantage of Local Modularization Be Wary of Modules Without Any Parameters Create Independent Modules Construct Abstract Data Types (ADTs) Tips for Parameter Design 23. Managing Code in the Database Executing Stored Code Transaction Integrity and Execute Authority Module Validation and Dependency Management Remote Procedure Calls Managing Stored Objects with SQL*Plus Using SQL to Examine Stored Objects Encrypting Stored Code 24. Debugging PL/SQL The Wrong Way to Debug Debugging Tips and Strategies 25. Tuning PL/SQL Applications Analyzing Program Performance Tuning Access to Compiled Code Tuning Access to Your Data Tuning Your Algorithms Overview of PL/SQL8 Enhancements 26. Tracing PL/SQL Execution The PL/SQL Trace Facility Tracing for Production Support Free Format Filtering Structured Interface Filtering Quick-and-Dirty Tracing VII. Appendixes A. What's on the Companion Disk? B. Calling Stored Procedures from PL/SQL Version 1.1 C. Built-In Packages Index
Responsibility: Steven Feuerstein with Bill Pribyl.

Abstract:

This text describes PL/SQL in terms of object features and tuning, and includes expanded discussions of debugging and tracing execution. Twenty-six chapters discuss topics including programming,  Read more...

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

All user tags (1)

View most popular tags as: tag list | tag cloud

  • IT  (by 1 person)

Similar Items

Related Subjects:(5)

User lists with this item (5)

Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


<http://www.worldcat.org/oclc/37741266>
library:oclcnum"37741266"
library:placeOfPublication
library:placeOfPublication
owl:sameAs<info:oclcnum/37741266>
rdf:typeschema:Book
schema:about
schema:about
schema:about
schema:about
schema:about
schema:about
schema:about
schema:about
schema:about
schema:about
schema:bookEdition"2nd ed."
schema:creator
schema:datePublished"1997"
schema:exampleOfWork<http://worldcat.org/entity/work/id/589804>
schema:inLanguage"en"
schema:name"Oracle PL/SQL programming"@en
schema:numberOfPages"987"
schema:publisher
schema:reviews
rdf:typeschema:Review
schema:itemReviewed<http://www.worldcat.org/oclc/37741266>
schema:reviewBody""Oracle8 presents PL/SQL programmers with new challenges by increasing both the possibilities and the complexities of the language. This new edition updates the original book for Oracle8, adding chapters describing the new PL/SQL object features (object types, collections, object views and external procedures). The second edition also contains a much-requested chapter on tuning PL/SQL, as well as expanded discussions of debugging and tracing PL/SQL execution. The accompanying diskette contains the Oracle PL/SQL Programming Companion Utilities Guide, an online tool developed by RevealNet, Inc., with nearly 100 files of source code and documentation prepared by the authors."--BOOK JACKET."
schema:url
schema:workExample

Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.