Advanced Oracle PL/SQL: Programming with Packages

Name: Advanced Oracle PL/SQL: Programming with Packages
Rating: 3.58 (19 reviews)
Author: Steven Feuerstein
ISBN: 9781565922389

Steven Feuerstein

19 valutazioni di Goodreads

Lingua: inglese

Editore: O'Reilly Media, 1996

1565922387 / 9781565922389

Brossura
Usato

Visualizza tutti i dettagli

Da: World of Books (was SecondSale), Montgomery, IL, U.S.A.World of Books (was SecondSale)

Venditore con 5 stelle

Venditore AbeBooks dal 20 dicembre 2007

Visualizza gli articoli di questo venditore

Brossura

Condizione: Usato - Molto buono

EUR 5,97

Spedizione gratuita

Spedito in U.S.A.

Quantità: 1 disponibili

Aggiungi al carrello

Resi gratuiti per 30 giorni

Lista dei preferitiCrea un desiderata per articoli simili

Descrizione dell’articolo da parte del venditore

Steven Feuerstein's first book, Oracle PL/SQL Programming, has become the classic reference to PL/SQL, Oracle's procedural extension to its SQL language. His new book looks thoroughly at one especially advanced and powerful part of the PL/SQL language -- the package. The use of packages can dramatically improve your programming productivity and code quality, while preparing you for object-oriented development in Oracle technology. In this book, Feuerstein explains how to construct packages -- and how to build them the right way. His "best practices" for building packages will transform the way you write packages and help you get the most out of the powerful, but often poorly understood, PL/SQL language. Much more than a book, Advanced Oracle PL/SQL Programming with Packages comes with a PC diskette containing a full-use software companion. Developed by Feuerstein, RevealNet's PL/Vision Lite is the first of its kind for PL/SQL developers: a library of thirty-plus PL/SQL packages. The packages solve a myriad of common programming problems and vastly accelerate the development of modular and maintainable applications. The packages provided in PL/Vision Lite fall into three categories: Building block packages: low-level development enhancers, including string parsers, a list manager, and an interface to PL/SQL tables. Developer utilities: programs that improve your PL/SQL development environment, including a code generator, a powerful substitute for SHOW ERRORS, and an online help delivery mechanism. Plug-and-play components: pieces of code that can be used as is in your own applications, including a high-level exception handler mechanism and a generic, reusable logging mechanism. In addition to describing the details of these packages, this book explores why and how they were built the way they were. You'll come away with an increased appreciation of the PL/SQL language and the power of packages. Most importantly, you'll be ready and eager to put that power to use immediately in your own applications.…

Codice articolo 00089490508

Contatta il venditore per questo articolo

Segnala questo articolo

Titolo: Advanced Oracle PL/SQL: Programming with Packages
Autore: Steven Feuerstein
Editore: O'Reilly Media
Anno di pubblicazione: 1996
Condizione: Very Good
Rilegatura: Brossura
Lingua: inglese
ISBN 10: 1565922387
ISBN 13: 9781565922389

Contenuti

Dedication; Foreword; Preface; Objectives of This Book; Structure of This Book; Conventions Used in This Book; About the Disk; About PL/Vision; Comments and Questions; Acknowledgments; Working With Packages; Chapter 1: PL/SQL Packages; 1.1 What Is a PL/SQL Package?; 1.2 What Are the Types and Layers of Packages?; 1.3 What Are the Benefits of Packages?; 1.4 Using Packages; 1.5 Types of Packages; 1.6 Building Packages; Chapter 2: Best Practices for Packages; 2.1 Starting With Packages; 2.2 Using Effective Coding Style for Packages; 2.3 Selecting Package Names; 2.4 Organizing Package Source Code; 2.5 Constructing the Optimal Interface to Your Package; 2.6 Building Flexibility Into Your Packages; 2.7 Building Windows Into Your Packages; 2.8 Overloading for Smart Packages; 2.9 Modularizing for Maintainable Packages; 2.10 Hiding Package Data; 2.11 Simultaneous Construction of Multiple Packages; Chapter 3: The PL/SQL Development Spiral; 3.1 The Basic Problem; 3.2 Adding Value; 3.3 Supplying Backward Compatibility; 3.4 Improving the User Interface; 3.5 Rough Waters Ahead; 3.6 Building a Structured Function; 3.7 Handling Program Assumptions; 3.8 Broadening the Scope; 3.9 Considering Implementation Options; 3.10 Choosing the Best Performer; 3.11 Don’t Forget Backward Compatibility; 3.12 Obliterating the Literals; 3.13 Glancing Backward, Looking Upward; PL/Vision Overview; Chapter 4: Getting Started with PL/Vision; 4.1 What Is PL/Vision?; 4.2 packagesin PL/VisionPL/Vision Package Bundles; 4.3 installingPL/Vision LitePL/VisioninstallingInstallation Instructionss; 4.4 installingPL/Vision help packagespackageshelpdocumentationInstalling Online Help for PL/Vision; 4.5 documentationonline helpUsing Online Help; 4.6 SQL*Plusscripts included on diskfilescreated during installationcodecreated during installationSummary of Files on Disk; Chapter 5: PL/Vision Package Specifications; 5.1 Common Package Elements; 5.2 p packagep: a DBMS_OUTPUT Substitute; 5.3 PLV: Top-Level Constants and Functions; 5.4 PLVcase: PL/SQL Code Conversion; 5.5 PLVcat: PL/SQL Code Cataloguing; 5.6 PLVchr: Operations on Single Characters; 5.7 PLVcmt: Commit Processing; 5.8 PLVddd: DDL Syntax Dump; 5.9 PLVdyn: Dynamic SQL Operations; 5.10 PLVexc: Exception Handling; 5.11 PLVfile: Operating System I/O Manager; 5.12 PLVfk: Foreign Key Interface; 5.13 PLVgen: PL/SQL Code Generator; 5.14 PLVhlp: Online Help Architechture; 5.15 PLVio: Input/Output Processing; 5.16 PLVlex: Lexical Analysis; 5.17 PLVlog: Logging Facility; 5.18 listsPLVlst package PLVlst: List Manager; 5.19 PLVmsg: Message Handling; 5.20 PLVobj: Object Interface; 5.21 PLVprs: String Parsing; 5.22 PLVprsps: PL/SQL Source Code Parsing; 5.23 PLVrb: Rollback Processing; 5.24 PLVstk: Stack Manager; 5.25 PLVtab: Table Interface; 5.26 PLVtkn: Token Table Interface; 5.27 PLVtmr: Program Performance Analyzer; 5.28 PLVtrc: Trace Facility; 5.29 PLVvu: Code and Error Viewing; Building Block Packages; Chapter 6: PLV: Top-Level Constants and Functions; 6.1 NULLsubstitution valuesubstitution value, NULLNull Substitution Value; 6.2 Setting the PL/Vision Date Mask; 6.3 Assertion Routines; 6.4 PLV Utilities; 6.5 typesdatatypestypesThe Predefined Datatypes; 6.6 The Predefined Constants; Chapter 7: p: A Powerful Substitute for DBMS_OUTPUT; 7.1 p packagell procedureUsing the l Procedure; 7.2 delimiterline separatorline separatorwhitespaceline separatorcharactersline separatorblank lineswhitespaceThe Line Separator; 7.3 stringsoutput prefixI/Ooutput prefixoutput prefixThe Output Prefix; 7.4 p packageoutput fromoutput from p packageI/Op package outputControlling Output from p; Chapter 8: PLVtab: Easy Access to PL/SQL Tables; 8.1 typestableUsing PLVtab-Based PL/SQL Table Types; 8.2 display functionDisplaying PLVtab Tables; 8.3 togglestable formatheaders, tableShowing Header Toggle; 8.4 Showing Row Number Toggle; 8.5 prefixtable row valuedisplay prefixtablesrow value prefixSetting the Display Prefix; 8.6 empty tablesdeletingtable rowsEmptying Tables with PLVtab; 8.7 Implementing PLVtab.display; Chapter 9: PLVmsg: Single-Sourcing PL/SQL Message Text; 9.1 PLVmsg Data Structures; 9.2 savingmessage textStoring Message Text; 9.3 Retrieving Message Text; 9.4 The Restriction Toggle; 9.5 Integrating PLVmsg with Error Handling; 9.6 Implementing load_ from_dbms; Chapter 10: PLVprs, PLVtkn, and PLVprsps: Parsing Strings; 10.1 PLVprs: Useful String Parsing Extensions; 10.2 PLVtkn: Managing PL/SQL Tokens; 10.3 PLVprsps: Parsing PL/SQL Strings; Chapter 11: PLVobj: A Packaged Interface to ALL_OBJECTS; 11.1 Why PLVobj?; 11.2 ALL_OBJECTS View; 11.3 Setting the Current Object; 11.4 Accessing ALL_OBJECTS; 11.5 Binding Objects to a Dynamic Cursor; 11.6 Populating a PL/SQL Table with Object Names; 11.7 A Programmatic Cursor FOR Loop; 11.8 Tracing PLVobj Activity; Chapter 12: PLVio: Reading and Writing PL/SQL Source Code; 12.1 Why PLVio?; 12.2 Code Repositories Supported by PLVio; 12.3 Managing the Source Repository; 12.4 The Source WHERE Clause; 12.5 Managing the Target Repository; 12.6 Reading From the Source; 12.7 Writing to the Target; 12.8 Saving and Restoring Settings; 12.9 Cleaning Up Source and Target; Chapter 13: PLVfile: Reading and Writing Operating System Files; 13.1 A Review of UTL_FILE; 13.2 Specifying the File in PLVfile; 13.3 Creating and Checking Existence of Files; 13.4 Opening and Closing Files; 13.5 Reading From a File; 13.6 Writing to a File; 13.7 Copying File Contents; 13.8 Displaying File Contents; 13.9 Handling File Errors with PLVfile; 13.10 Tracing PLVfile Activity; Developer Utility Packages; Chapter 14: PLVtmr: Analyzing Program Performance; 14.1 Toggling the Timer; 14.2 Capturing the Start Time; 14.3 Retrieving and Displaying the Elapsed Time; 14.4 Using PLVtmr in Scripts; Chapter 15: PLVvu: Viewing Source Code and Compile Errors; 15.1 Compiling PL/SQL Code in SQL*Plus; 15.2 Displaying Compile Errors; 15.3 Displaying Source Code; 15.4 Implementing PLVvu; Chapter 16: PLVgen: Generating PL/SQL Programs; 16.1 Best PracticesOptions for Best Practices; 16.2 Code Generated by PLVgen; 16.3 Modifying PLVgen Behavior; 16.4 Implementing PLVgen; Chapter 17: PLVhlp: Online Help for PL/SQL Programs; 17.1 Who Needs Online Help?; 17.2 Current Sources of Information; 17.3 What Is “Online Help” for Stored Code?; 17.4 Using PLVhlp; 17.5 Implementing PLVhlp; Chapter 18: PLVcase and PLVcat: Converting and Analyzing PL/SQL Code; 18.1 PLVcase: Converting the Case of PL/SQL Programs; 18.2 PLVcat: Cataloguing PL/SQL Source Code; Plug-and-Play Packages; Chapter 19: PLVdyn and PLVfk: Dynamic SQL and PL/SQL; 19.1 About Plug-and-Play; 19.2 Declarative Programming in PL/SQL; 19.3 The Dynamic Packages of PL/Vision; 19.4 PLVdyn: A Code Layer over DBMS_SQL; 19.5 DML Operations; 19.6 PLVfk: Generic Foreign Key Lookups; Chapter 20: PLVcmt and PLVrb: Commit and Rollback Processing; 20.1 PLVcmt: Enhancing Commit Processing; 20.2 PLVrb: Performing Rollbacks; Chapter 21: PLVlog and PLVtrc: Logging and Tracing; 21.1 PLVlog: Logging Activity in PL/SQL Programs; 21.2 PLVtrc: Tracing Execution of PL/SQL Programs; Chapter 22: PLVexc: Exception Handling; 22.1 The Challenge of Exception Handling; 22.2 Application-Specific Exception Packages; 22.3 Implementing PLVexc; Testing Your Knowledge; Appendix: PL/SQL Exercises; Exercises; Solutions; Colophon;|

Dedication
Foreword
Preface
Working With Packages
- Chapter 1: PL/SQL Packages
- Chapter 2: Best Practices for Packages
- Chapter 3: The PL/SQL Development Spiral
PL/Vision Overview
- Chapter 4: Getting Started with PL/Vision
- Chapter 5: PL/Vision Package Specifications
Building Block Packages
- Chapter 6: PLV: Top-Level Constants and Functions
- Chapter 7: p: A Powerful Substitute for DBMS_OUTPUT
- Chapter 8: PLVtab: Easy Access to PL/SQL Tables
- Chapter 9: PLVmsg: Single-Sourcing PL/SQL Message Text
- Chapter 10: PLVprs, PLVtkn, and PLVprsps: Parsing Strings
- Chapter 11: PLVobj: A Packaged Interface to ALL_OBJECTS
- Chapter 12: PLVio: Reading and Writing PL/SQL Source Code
- Chapter 13: PLVfile: Reading and Writing Operating System Files
Developer Utility Packages
- Chapter 14: PLVtmr: Analyzing Program Performance
- Chapter 15: PLVvu: Viewing Source Code and Compile Errors
- Chapter 16: PLVgen: Generating PL/SQL Programs
- Chapter 17: PLVhlp: Online Help for PL/SQL Programs
- Chapter 18: PLVcase and PLVcat: Converting and Analyzing PL/SQL Code
Plug-and-Play Packages
- Chapter 19: PLVdyn and PLVfk: Dynamic SQL and PL/SQL
- Chapter 20: PLVcmt and PLVrb: Commit and Rollback Processing
- Chapter 21: PLVlog and PLVtrc: Logging and Tracing
- Chapter 22: PLVexc: Exception Handling
Testing Your Knowledge
- Appendix: PL/SQL Exercises
Colophon

"Descrizione articolo" può appartenere a un’altra edizione di questo titolo.

World of Books (was SecondSale)

Montgomery, IL, U.S.A.

Venditore con 5 stelle

Venditore AbeBooks dal 20 dicembre 2007

Tariffe di spedizione nazionale per U.S.A.

Articolo	Da 4 a 12 giorni lavorativi	Da 3 a 6 giorni lavorativi
Primo articolo	EUR 0,00	EUR 9,61

I tempi di consegna sono stabiliti dai venditori e variano in base al corriere e al paese. Gli ordini che devono attraversare una dogana possono subire ritardi e spetta agli acquirenti pagare eventuali tariffe o dazi associati. I venditori possono contattarti in merito ad addebiti aggiuntivi dovuti a eventuali maggiorazioni dei costi di spedizione dei tuoi articoli.

Metodi di pagamento

Descrizione dello Store

Founded in 2002, World of Books is a leading online destination for buying and selling both preloved and new books, committed to making sustainable reading accessible to all. With a mission to help people read more and waste less, World of Books offers a huge range of affordable, high-quality books — giving both new and preloved titles a second life. The company also operates World of Books – Sell Your Books, an easy-to-use platform that allows customers to trade in unwanted books for cash, helping to keep books in circulation while promoting sustainability. As a Certified B Corp, World of Books is driven by a vision to become the world’s largest and most sustainable dedicated online bookstore. The company measures its success through the positive environmental impact it creates, the value it provides to customers, and its ability to operate profitably while supporting its sustainable mission …

Informazioni sull’azienda del venditore

SBYB, Inc.

900 Knell Rd
Montgomery, IL U.S.A. 60538

Contatta il venditoreVisualizza gli articoli di questo venditoreVisita la vetrina del venditore

Condizioni di vendita

We guarantee the condition of every book as it's described on the Abebooks web sites. If you're dissatisfied with your purchase (Incorrect Book/Not as Described/Damaged) or if the order hasn't arrived, you're eligible for a refund within 30 days of the estimated delivery date. If you've changed your mind about a book that you've ordered, please use the Ask bookseller a question link to contact us and we'll respond within 2 business days.

Diritto di recesso

Se sei un consumatore puoi recedere dal contratto in conformità con quanto segue. Per Consumatore si intende qualsiasi persona fisica che agisce per scopi estranei alla propria attività commerciale, imprenditoriale, artigianale o professionale.

Informazioni sul diritto di recesso

Diritto legale di recesso

Hai il diritto di recedere dal presente contratto entro 14 giorni senza fornire alcuna motivazione.

Il periodo di recesso scade dopo 14 giorni dal giorno in cui tu o una terza parte, diversa dal vettore e da te indicata, acquisisce il possesso fisico dell'ultimo bene o dell'ultimo lotto o pezzo.

Per esercitare il diritto di recesso, compila e invia elettronicamente una dichiarazione esplicita sul nostro sito Web, alla voce “I miei acquisti” nella sezione “Mio account”. Ti comunicheremo senza indugio una conferma di ricezione di tale recesso su un supporto durevole (ad es. via e-mail).

Per rispettare il termine di recesso, è sufficiente inviare la comunicazione relativa all'esercizio del diritto di recesso prima della scadenza del periodo di recesso stesso.

Effetti del recesso

In caso di recesso dal presente contratto, ti rimborseremo tutti i pagamenti ricevuti, compresi i costi di spedizione (ad eccezione dei costi supplementari derivanti dalla tua eventuale scelta di un tipo di spedizione diverso dal tipo meno costoso di consegna standard da noi offerto).

Potremo effettuare una detrazione dal rimborso per la perdita di valore dei beni forniti, qualora tale perdita sia il risultato di una manipolazione non necessaria da parte tua.

Eseguiremo il rimborso senza indebito ritardo e non oltre 14 giorni dal giorno in cui saremo informati della tua decisione di recedere dal presente contratto.

Il rimborso sarà effettuato utilizzando lo stesso mezzo di pagamento da te usato per la transazione iniziale, salvo che tu non abbia espressamente concordato altrimenti; in ogni caso, non dovrai sostenere alcun costo quale conseguenza di tale rimborso.

Possiamo trattenere il rimborso finché non avremo ricevuto i beni oppure finché non avrai fornito la prova di averli rispediti, a seconda di quale condizione si verifichi per prima.

Dovrai rispedire i beni o consegnarli a World of Books (was SecondSale), Montgomery, Illinois, U.S.A., senza indebito ritardo e, in ogni caso, entro 14 giorni dal giorno in cui ci hai comunicato la tua volontà di recedere dal presente contratto. Il termine è rispettato se rispedisci i beni prima della scadenza del periodo di 14 giorni. I costi diretti della restituzione dei beni saranno a tuo carico. Sei responsabile solo della diminuzione del valore dei beni risultante da una manipolazione diversa da quella necessaria per stabilire la natura, le caratteristiche e il funzionamento dei beni stessi.

Eccezioni al diritto di recesso

Il diritto di recesso non si applica a:

La fornitura di giornali, periodici o riviste ad eccezione dei contratti di abbonamento; e
La fornitura di contenuto digitale non fornito su un supporto materiale (ad es. su un CD o DVD), se al momento dell'invio dell'ordine hai accettato l'inizio dell'esecuzione e hai riconosciuto che non avresti potuto recedere una volta iniziata l'esecuzione.

Condizioni di spedizione

Shipping costs are based on books weighing 2.2 LB, or 1 KG. If your book order is heavy or oversized, we may contact you to let you know extra shipping is required.