Oracle PL/SQL Programming
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Home > Computing and Information Technology > Databases > Database software > Oracle PL/SQL Programming
Oracle PL/SQL Programming

Oracle PL/SQL Programming


     0     
5
4
3
2
1



International Edition


X
About the Book

This text has been thoroughly revised and updated to include the latest Oracle releases - Oracle8i and Oracle9i - the "Internet databases" that communicate with other technologies, such as Java, to run powerful e-commerce applications. Oracle has made substantial changes to the PL/SQL language, and developers who want to take full advantage of its power should find the information they need in this book. This new edition of the book includes all PL/S QL language features up to and including Oracle 9i Release 2 (9.2). Regardless of the version you are using, from Oracle 7.3.4 to Oracle 9i, this book will answer your questions. In addition, Oracle PL/SQL Programming now contains much-requested new chapters on Oracle triggers, the internal architecture of PL/SQL in the Oracle database, and the use of PL/SQL with Java. The authors have carefully constructed each chapter of this edition with three objectives: to help you take full advantage of PL/SQL, learn to use PL/SQL to solve your problems, and to write efficient, maintainable code. Beginning with an introduction to PL/SQL programming and continuing through advanced PL/SQL topics, the book covers: PL/SQL language fundamentals; PL/SQL program structure; types of program data; the connection of PL/SQL to the underlying database; application construction; managing your PL/SQL code base; if you're new to PL/SQL, reading this book will improve your skills and help your understanding. If you're already a proficient PL/SQL programmer, you'll be able to extract particular techniques for immediate application. Whether you use this book as a teaching guide or reference, you'll find it will have a significant impact on your ability to use PL/SQL more effectively.

Table of Contents:
Preface Part I. Programming in PL/SQL 1. Introduction to PL/SQL What Is PL/SQL? The Origins of PL/SQL So This Is PL/SQL About PL/SQL Versions Resources for PL/SQL Developers Some Words of Advice 2. Creating and Running PL/SQL Code SQL*Plus Performing Essential PL/SQL Tasks Oracle's PL/SQL-Based Developer Tools Calling PL/SQL from Other Languages And What Else? 3. Language Fundamentals PL/SQL Block Structure The PL/SQL Character Set Identifiers Literals The Semicolon Delimiter Comments The PRAGMA Keyword Labels Part II. PL/SQL Program Structure 4. Conditional and Sequential Control IF Statements CASE Statements The GOTO Statement The NULL Statement 5. Iterative Processing with Loops Loop Basics The Simple Loop The WHILE Loop The Numeric FOR Loop The Cursor FOR Loop Loop Labels Tips for Iterative Processing 6. Exception Handlers How PL/SQL Deals with Errors Defining Exceptions Raising Exceptions Handling Exceptions Part III. PL/SQL Program Data 7. Working with Program Data Naming Your Program Data Overview of PL/SQL Datatypes Declaring Program Data Programmer-Defined Subtypes Conversion Between Datatypes 8. Strings The Impact of Character Sets String Datatypes String Issues String Functions NLS Functions 9. Numbers Numeric Datatypes Number Conversions Numeric Functions 10. Dates and Timestamps Date and Time Datatypes Date and Timestamp Conversions Date/Time Arithmetic Date/Time Functions 11. Records and Collections Records in PL/SQL Collections in PL/SQL Declaring Collection Types and Collections Where Collections Can Be Used Collection Built-Ins (Methods) Working with Collections Collection Pseudo-Functions Maintaining Collections Choosing a Collection Type 12. Miscellaneous Datatypes The BOOLEAN Datatype The RAW Datatype The UROWID and ROWID Datatypes The LOB Datatypes Working with LOBs Predefined Object Types Part IV. SQL in PL/SQL 13. DML and Transaction Management DML in PL/SQL Bulk DML with the FORALL Statement Transaction Management Autonomous Transactions 14. Data Retrieval Cursor Basics Working with Implicit Cursors Working with Explicit Cursors BULK COLLECT SELECT...FOR UPDATE Cursor Variables Cursor Expressions (Oracle9i) 15. Dynamic SQL and Dynamic PL/SQL NDS Statements Multirow Queries with Cursor Variables Binding Variables Working with Objects and Collections Building Applications with NDS NDS Utility Package Comparing NDS and DBMS_SQL Part V. PL/SQL Application Construction 16. Procedures, Functions, and Parameters Modular Code Procedures Functions Parameters Local Modules Module Overloading Forward Declarations Advanced Topics Go Forth and Modularize! 17. Packages Why Packages? Rules for Building Packages Rules for Calling Packaged Elements Working with Package Data When to Use Packages Packages and Object Types 18. Triggers DML Triggers DDL Triggers Database Event Triggers INSTEAD OF Triggers AFTER SUSPEND Triggers Maintaining Triggers 19. Managing PL/SQL Applications Managing and Analyzing Code in the Database Protecting Stored Code Using Native Compilation Testing PL/SQL Programs Debugging PL/SQL Programs Tuning PL/SQL Programs Improving Application Performance Part VI. Advanced PL/SQL Topics 20. PL/SQL's Runtime Architecture Looking Under the Hood Dependency Management PL/SQL's Use of Memory in the Oracle Server The Processing of Server-Side PL/SQL PL/SQL Code on the Client Execution Authority Models Hardware for PL/SQL: Bigger = Better? What You Need to Know 21. Object-Oriented Aspects of PL/SQL Introduction to Oracle's Object Features An Extended Example Object Views Maintaining Object Types and Object Views Pontifications 22. Calling Java from PL/SQL Oracle and Java Getting Ready to Use Java in Oracle A Simple Demonstration Using loadjava Using dropjava Managing Java in the Database Using DBMS_ JAVA Publishing and Using Java in PL/SQL 23. External Procedures Introduction to External Procedures The Oracle Net Configuration Creating an Oracle Library Writing the Call Specification Raising an Exception from the Called C Program Nondefault Agents Maintaining External Procedures Index

About the Author :
Steven Feuerstein is considered one of the world's leading experts on the Oracle PL/SQL language. He is also the author of the sequel to Oracle PL/SQL Programming, Advanced Oracle PL/SQL Programming with Packages (O'Reilly & Associates, 1996), and Oracle Built-in Packages (O'Reilly & Associates, 1998). Steven has been developing software since 1980 and worked for Oracle Corporation from 1987 to 1992. He is a partner with RevealNet, Inc. (www.revealnet.com) and is the chief architect of the RevealNet products, PL/SQL Knowledge Base and PL/Vision (a code library of prebuilt PL/SQL packages that accelerates PL/SQL-based application development). Steven also sysops RevealNet's "PL/SQL Pipeline," an online community for PL/SQL developers (www.revealnet.com/plsql-pipeline). He can be reached through email at feuerstein@revealnet.com. Steven is also president of PL/Solutions, which offers training and consulting on both PL/Vision and PL/SQL (www.plsolutions.com). Finally (on the Oracle side of Steven's life), he serves as codirector of the Oracle Practice at SSC, a systems management consulting firm based in Chicago (www.saraswati.com). Steven shares his Rogers Park, Chicago, Georgian with his wife Veva, his youngest son Eli, two cats (Sister Itsacat and Moshe Jacobawitz), and Mercury (the Congo Red African Gray parrot). His older son, Chris, is busy making music and creating art nearby. Steven is a member of the Board of Directors of the Crossroads Fund, which provides grants to organizations in Chicago working for social change. Bill Pribyl, author, teacher, and software consultant, is coauthor of the best-selling Oracle PL/SQL Programming and its companion pocket reference, both published by O'Reilly & Associates. An Oracle user for 15 years, Bill has consulted on many aspects of using Oracle products. He recently spearheaded PLNet.org, a Web-based repository where developers can share open source PL/SQL. At home in Houston, Bill volunteers with a Christian organization teaching computer skills to low-income clients, and he says his next project will be persuading fellow database technologists to contemplate the ethical and moral implications of all their work. Visit Bill at www.datacraft.com.


Best Sellers


Product Details
  • ISBN-13: 9780596003814
  • Publisher: O'Reilly Media
  • Publisher Imprint: O'Reilly Media
  • Edition: Revised edition
  • Language: English
  • Weight: 1274 gr
  • ISBN-10: 0596003811
  • Publisher Date: 29 Oct 2002
  • Binding: Paperback
  • Height: 233 mm
  • Returnable: N
  • Width: 178 mm


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Oracle PL/SQL Programming
O'Reilly Media -
Oracle PL/SQL Programming
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Oracle PL/SQL Programming

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    Fresh on the Shelf


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!