Acrobat X Files

Home > Programming > Oracle Programming

Engineering Better PL/SQL

Sort Desciption:

Softwares TOAD for Oracle to write your SQL and PL/SQL code. ..... Figure 8 shows what TOADs CodeXpert reveals as the program units metric scores. ...

Content Inside:

Engineering Better PL/SQLPage 1Engineering Better PL/SQLPL/SQL is a great language. Its relatively simple to learn is well integrated with theOracle database and can often be the most efficient way to perform complex or largescale database operations. In fact PL/SQL is so useful its difficult to believe that itsorigin is SQL*Forms and that PL/SQL was once was an optional cost addon to thedatabase. Working with Oracle over the past few decades has come a long way andPL/SQL had evolved into a mature robust and highly functional database language.However contrary to logical and reasonable expectations a simple to learn yet robustlanguage like PL/SQL does not automatically guarantee programs which are readablemaintainable effective (i.e. correct) and efficient. In fact some of the worst programsIve seen over the past twenty years of Oracle development were written in PL/SQL. Ihave often been quite amazed at just how easily one can shoot themselves in the footwith PL/SQL and how often it goes undetected until a major production crisis occurs.So the question is How do we engineer better PL/SQL? This paper will examine somecommonly used manual methods and their shortcomings and then will offer some morescientific advice for how to improve upon the PL/SQL development process. And whilethis paper will demonstrate techniques using Quest Softwares TOAD for Oracle productthe practices espoused within are actually based on industry standards (although as of yetnot universally prevalent although hoping that papers like this may help to correct that).The Cost of Software DefectsIn order to see the full value for engineering better PL/SQL we must first understand andappreciate the ramifications for not doing so. Thus looking beyond the simple yet highlyrelevant fact that our jobs may well depend on it what does poorly engineered code costthese days? The answers are quite staggering. One survey estimates that inferior softwareengineering and inadequate testing in 2002 alone cost ...

Source: www.toadsoft.com

 

Related Files

Oracle Database 10g: Program with PL/SQL

Filed under: Programming and Oracle Programming
Oracle Database 10g: Program with PL/SQL. Duration 5 Days. What you will learn. This class is applicable to Oracle8i Oracle9i and Oracle Database 10g users ...

Oracle JDeveloper for Forms & PL/SQL Developers; A Guide to J2EE ...

Filed under: Programming and Oracle Programming
The most efficient way to learn J2EE programming techniques. Two Oracle experts ... Market. Developers currently using Oracle Forms and the PL/SQL language ...

Oracle/SQL Tutorial

Filed under: Programming and Oracle Programming
C.J. Date and Hugh Darwen: A Guide to the SQL Standard (4th Edition) AddisonWesley ... Oracle Data Dictionary. 23. 4. Application Programming. 4.1. PL/SQL ...

Oracle PLSQL Programming

Filed under: Programming and Oracle Programming
ORACLE PL/SQL PROGRAMMING. Course Code 2PTC313. Module Aims. The aims of the module are to:. Support students to develop a good understanding PL/SQL. ...

Oracle 10 g : Java Programming

Filed under: Programming and Oracle Programming
Oracle 10g: Java Programming. Duration 5 Days. What you will learn:. This course teaches the concepts and essential elements of the Java language. ...