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

Oracle PL/SQL best practices

Author: Steven Feuerstein
Publisher: Beijing ; Sebastopol : O'Reilly, ©2008.
Edition/Format:   Print book : English : 2nd edView all editions and formats
Database:WorldCat
Summary:
"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.
Rating:

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

Subjects
More like this

 

Find a copy in the library

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

Details

Material Type: Internet resource
Document Type: Book, Internet Resource
All Authors / Contributors: Steven Feuerstein
ISBN: 9780596514105 0596514107
OCLC Number: 180874700
Notes: "Covers Oracle database 11g"--Cover.
Description: xix, 270 pages : illustrations ; 23 cm
Contents: 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 --
Best practices quick reference --
Resources for PL/SQL developers.
Responsibility: Steven Feuerstein.
More information:

Abstract:

Summarizes PL/SQL practices in nine categories such as overall PL/SQL application development; programming standards; program testing, tracing, and debugging; variables and data structures; control  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)
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


Primary Entity

<http://www.worldcat.org/oclc/180874700> # Oracle PL/SQL best practices
    a schema:Book, schema:CreativeWork ;
   library:oclcnum "180874700" ;
   library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/2452579587#Place/sebastopol> ; # Sebastopol
   library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/2452579587#Place/beijing> ; # Beijing
   library:placeOfPublication <http://id.loc.gov/vocabulary/countries/cc> ;
   schema:about <http://experiment.worldcat.org/entity/work/data/2452579587#Topic/pl_sql_computer_language> ; # PL/SQL (Computer language)
   schema:about <http://dewey.info/class/005.7565/e22/> ;
   schema:about <http://id.worldcat.org/fast/1093575> ; # Relational databases
   schema:about <http://id.loc.gov/authorities/subjects/sh85035849> ; # Database management--Computer programs
   schema:about <http://id.worldcat.org/fast/888040> ; # Database management--Computer programs
   schema:about <http://id.worldcat.org/fast/1049863> ; # PL/SQL (Computer program language)
   schema:about <http://id.worldcat.org/fast/1363816> ; # Oracle (Computer file)
   schema:about <http://experiment.worldcat.org/entity/work/data/2452579587#CreativeWork/oracle_computer_software> ; # Oracle (Computer software)
   schema:about <http://experiment.worldcat.org/entity/work/data/2452579587#Topic/database_management> ; # Database management
   schema:about <http://experiment.worldcat.org/entity/work/data/2452579587#CreativeWork/oracle_computer_file> ; # Oracle (Computer file)
   schema:bookEdition "2nd ed." ;
   schema:bookFormat bgn:PrintBook ;
   schema:copyrightYear "2008" ;
   schema:creator <http://viaf.org/viaf/2626430> ; # Steven Feuerstein
   schema:datePublished "2008" ;
   schema:description ""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."@en ;
   schema:description "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 -- Best practices quick reference -- Resources for PL/SQL developers."@en ;
   schema:exampleOfWork <http://worldcat.org/entity/work/id/2452579587> ;
   schema:inLanguage "en" ;
   schema:name "Oracle PL/SQL best practices"@en ;
   schema:productID "180874700" ;
   schema:publication <http://www.worldcat.org/title/-/oclc/180874700#PublicationEvent/beijing_sebastopol_o_reilly_2008> ;
   schema:publisher <http://experiment.worldcat.org/entity/work/data/2452579587#Agent/o_reilly> ; # O'Reilly
   schema:url <http://catdir.loc.gov/catdir/enhancements/fy1010/2009289265-t.html> ;
   schema:workExample <http://worldcat.org/isbn/9780596514105> ;
   wdrs:describedby <http://www.worldcat.org/title/-/oclc/180874700> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/2452579587#CreativeWork/oracle_computer_software> # Oracle (Computer software)
    a schema:CreativeWork ;
   schema:name "Oracle (Computer software)" ;
    .

<http://experiment.worldcat.org/entity/work/data/2452579587#Topic/database_management> # Database management
    a schema:Intangible ;
   schema:name "Database management"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/2452579587#Topic/pl_sql_computer_language> # PL/SQL (Computer language)
    a schema:Intangible ;
   schema:name "PL/SQL (Computer language)"@en ;
    .

<http://id.loc.gov/authorities/subjects/sh85035849> # Database management--Computer programs
    a schema:Intangible ;
   schema:name "Database management--Computer programs"@en ;
    .

<http://id.worldcat.org/fast/1049863> # PL/SQL (Computer program language)
    a schema:Intangible ;
   schema:name "PL/SQL (Computer program language)"@en ;
    .

<http://id.worldcat.org/fast/1093575> # Relational databases
    a schema:Intangible ;
   schema:name "Relational databases"@en ;
    .

<http://id.worldcat.org/fast/1363816> # Oracle (Computer file)
    a schema:CreativeWork ;
   schema:name "Oracle (Computer file)" ;
    .

<http://id.worldcat.org/fast/888040> # Database management--Computer programs
    a schema:Intangible ;
   schema:name "Database management--Computer programs"@en ;
    .

<http://viaf.org/viaf/2626430> # Steven Feuerstein
    a schema:Person ;
   schema:familyName "Feuerstein" ;
   schema:givenName "Steven" ;
   schema:name "Steven Feuerstein" ;
    .

<http://worldcat.org/isbn/9780596514105>
    a schema:ProductModel ;
   schema:isbn "0596514107" ;
   schema:isbn "9780596514105" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

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