Extensive and extendable PL/SQL code library

Information overload is a serious problem in today's Internet-enabled world.  QCGU combats information overload by providing highly structured roadmaps to domain expertise.  In the world of search engines, you spend lots of time sifting through undifferentiated links.  In the world of QCGU, experts in a given field guide you to your desired destination or content.  Why have to depend on a hidden, mysterious search algorithm, when you can follow the guidance of an expert?  QCGU 1.0.1 features hundreds of scripts containing reusable code and templates for PL/SQL developers and Oracle DBAs.  Best of all, the script repository is extensible: you can create your own application-specific templates and establish your own toolbox of handy utilities.

The PL/SQL code library consists of two major elements:

• PL/SQL by Feuerstein: scripts that reflect Steven Feuerstein's accumulated expertise on the PL/SQL language, all in the form of reusable code and templates that can be applied to your database objects.
• QCGU Development Architecture for PL/SQL (QDA): a set of scripts that offer an overall framework, also designed by Feuerstein, for PL/SQL development.  Its major components are SQL access packages (aka, table APIs), generic error handling packages and tables, and administrative script generation.

If you write PL/SQL-based applications, these script sets can save you enormous amounts of time, particularly the QDA.  Here are some additional details

The PL/SQL by Feuerstein script set recognizes that many PL/SQL developers may not be able to adapt a framework to guide their development.  Instead, PL/SQL by Feuerstein offers programs and templates that cover a wide range of topics on the PL/SQL language.  There are, for example, 57 scripts that cover collections, a crucial but mostly unknown feature of PL/SQL; 59 scripts that offer accelerators for writing SQL inside PL/SQL; 35 scripts, most of them reusable packages, that help you use various aspects of PL/SQL built-in functionality; and much more.

The QCGU Development Architecture or QDA is an evolving set of standards and frameworks that we used to develop the PL/SQL-based backend of QCGU.  We found this architecture to be vastly superior to anything we'd used previously.  Since QCGU is designed to be a mechanism for sharing such ideas and code elements, we decided to expose QDA to users of QCGU, allowing you to develop your own applications following and taking advantage of this architecture.*

The QDA is made up of the following elements:

• Table API or encapsulation packages: Rather than write SQL statements in your application code, you call procedures and functions, generated by QCGU, to take care of most of your typical SQL.  By taking advantage of the encapsulation packages, you can save many hours of effort each week.
• Error definition and management: Define within QCGU your own error categories and errors for an application.  Raise and handle these errors in your code using the QD_RUNTIME package.  Analyze and manage this error information via the QCGU Runtime Monitor.
• Administrative script generation: Rather than manually maintain scripts to install the code and database objects for the QDA, QCGU will generate these scripts for you, based on information in your QCGU application definition.