عنوان

Oracle PL/SQL best practices /

(Number (ISBN

0596514107

(Number (ISBN

9780596514105

Number

b778460

Title Proper

Oracle PL/SQL best practices /

General Material Designation

[Book]

First Statement of Responsibility

Steven Feuerstein.

Edition Statement

2nd ed.

Place of Publication, Distribution, etc.

Sebastopol, Calif. :

Name of Publisher, Distributor, etc.

O'Reilly Media, Inc.,

Date of Publication, Distribution, etc.

2007, ©2008.

Specific Material Designation and Extent of Item

1 online resource (xix, 270 pages) :

Other Physical Details

illustrations

Text of Note

Includes bibliographical references (pages 252-258) and index.

Text of Note

1. The Big Picture -- Successful Applications Are Never an Accident -- Best Practices for Successful Applications -- 2. Real Developers Follow Standards -- Best Practices for Developing and Using Standards -- 3. Life After Compilation -- Testing, Tracing, and Debugging -- Best Practices for Testing, Tracing, and Debugging -- 4. What's Code Without Variables? -- Best Practices for Declaring Variables and Data Structures -- Best Practices for Using Variables and Data Structures -- Best Practices for Declaring and Using Package Variables -- 5. Developer As Traffic Cop -- Best Practices for Conditional and Boolean Logic -- Best Practices for Loop Processing -- Best Practices for Branching Logic -- 6. Doing the Right Thing When Stuff Goes Wrong -- Best Practices for Understanding Error Handling -- Best Practices for Nitty-Gritty, Everyday Exception Programming -- Best Practices for Coding Defensively -- 7. Break Your Addiction to SQL -- SQL is Bad! -- General SQL Best Practices -- Best Practices for Querying Data from PL/SQL -- Best Practices for Changing Data from PL/SQL -- Best Practices for Dynamic SQL -- 8. Playing with Blocks (of Code) -- Best Practices for Parameters -- Best Practices for Procedures and Functions -- Best Practices for Packages -- Best Practices for Triggers -- 9. My Code Runs Faster Than Your Code -- Best Practices for Finding Slow Code -- Best Practices for High-Impact Tuning -- Best Practices for Other Tuning -- A. Best Practices Quick Reference -- B. Resources for PL/SQL Developers.

0

Text of Note

"This book summarizes PL/SQL best practices in nine major categories: overall PL/SQL application development; programming standards; program testing, tracing, and debugging; variables and data structures; control logic; error handling; the sue of SQL in PL/SQL; building procedures, functions, packages, triggers; and overall program performance"--Cover.

Source for Acquisition/Subscription Address

Safari Books Online

Stock Number

CL0500000019

Oracle (Computer file)

Oracle (Computer file)

Oracle (Computer file)

PL/SQL (Computer program language)

Relational databases.

PL/SQL (Computer program language)

PL/SQL (Computer program language)

Relational databases.

Relational databases.

Number

Class number

Book number

Feuerstein, Steven.

Date of Transaction

20201203120413.0

Cataloguing Rules (Descriptive Conventions))

pn

Electronic name

[Book]

Y