Skip to main content
SpringerLink
Log in
Apress

Oracle9i PL/SQL

A Developer's Guide

  • Book
  • © 2003

Overview

Authors:
  1. Bulusu Lakshman
    View author publications

    You can also search for this author in PubMed   Google Scholar

  • Highlights key points in each chapter as tips for solving real-world problems

  • Covers some technical topics NOT included in the PL/SQL help pages or other Oracle documentation

  • Dicsusses Oracle PL/SQL 9i from an application developer's perspective

  • Includes supplementary material: sn.pub/extras

  • 1848 Accesses

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (16 chapters)

  1. Front Matter

    Pages i-xxiii
    Download chapter PDF

  2. Introduction

    1. Front Matter

      Pages 1-1
      Download chapter PDF

    2. Introduction to PL/SQL

      • Bulusu Lakshman
      Pages 3-30

  3. Non-Object-Oriented Features in PL/SQL 9i

    1. Front Matter

      Pages 31-31
      Download chapter PDF

    2. Cursors

      • Bulusu Lakshman
      Pages 33-94

    3. PL/SQL Records and Index-by Tables

      • Bulusu Lakshman
      Pages 95-135

    4. Error Message Handling

      • Bulusu Lakshman
      Pages 137-173

    5. Stored Subprograms (Procedures, Functions, and Packages)

      • Bulusu Lakshman
      Pages 175-253

    6. Database Triggers

      • Bulusu Lakshman
      Pages 255-290

    7. Native Dynamic SQL and Dynamic PL/SQL

      • Bulusu Lakshman
      Pages 291-313

    8. Autonomous Transactions

      • Bulusu Lakshman
      Pages 315-331

    9. Native Bulk Binds

      • Bulusu Lakshman
      Pages 333-357

  4. Object-Oriented Features in PL/SQL 9i

    1. Front Matter

      Pages 359-359
      Download chapter PDF

    2. The World of Objects

      • Bulusu Lakshman
      Pages 361-431

    3. Collections (VARRAYS and Nested Tables)

      • Bulusu Lakshman
      Pages 433-478

    4. Large Objects

      • Bulusu Lakshman
      Pages 479-505

  5. PL/SQL with Java and the Web

    1. Front Matter

      Pages 507-507
      Download chapter PDF

    2. Floating in Java

      • Bulusu Lakshman
      Pages 509-554

    3. PL/SQL and the Web

      • Bulusu Lakshman
      Pages 555-593

  6. PL/SQL Performance and Standards

    1. Front Matter

      Pages 595-595
      Download chapter PDF
Back to top

Keywords

About this book

Oracle9i PL/SQL: A Developers Guide is intended for both intermediate-level Oracle developers who are designing or coding applications in SQL and PL/SQL and for advanced PL/SQL programmers who need to learn new PL/SQL 9ifeatures. In addition to providing developers with detailed coverage of the PL/SQL 9i language itself, author Bulusu Lakshman covers the techniques of using PL/SQL 9i for server-side applications and provides the methodology for implementing robust applications. Lakshman also mentors developers in implementing effective techniques for real-world and code-centric Oracle applications that, in the long run, will save them time and energy.

Oracle9i PL/SQL: A Developers Guide is a solid source for the development of Oracle9i PL/SQL applications. Developers incorporating these technologies into new applications and those migrating from earlier versions will both find Lakshman's expert treatment of the topic beneficial.

About the author

Bulusu Lakshman is an experienced Oracle developer with more than 10 years of software design and development experience using Oracle and its related tools, including PL/SQL and Java. He's the author of Oracle Developer Forms Techniques and Oracle and Java Development, both of which have been well received. He also holds an Oracle Master credential from the Oracle Corporation, is an Oracle Certified Professional (OCP) application developer, and is a double honors graduate in computer science and engineering and mathematics. He has presented at numerous international and national conferences on Oracle and its tools, and published articles in various technical magazines and journals. Lakshman is employed by Compunnel Software Group Inc., a leading technical consulting firm based in New Jersey.

Bibliographic Information

  • Book Title: Oracle9i PL/SQL

  • Book Subtitle: A Developer's Guide

  • Authors: Bulusu Lakshman

  • DOI: https://doi.org/10.1007/978-1-4302-1154-9

  • Publisher: Apress Berkeley, CA

  • eBook Packages: Springer Book Archive

  • Copyright Information: Bulusu Lakshman 2003

  • Softcover ISBN: 978-1-59059-049-2Published: 15 November 2002

  • eBook ISBN: 978-1-4302-1154-9Published: 12 November 2002

  • Edition Number: 1

  • Number of Pages: XXIII, 696

  • Topics: Database Management, Software Engineering/Programming and Operating Systems

Publish with us

Policies and ethics

Back to top

Search

Navigation