Flexible Code Generation

Ever have the feeling of déjà vu code—the feeling you've written those lines before?  That's probably because you did.  Most of the code we write follows one or another fairly predictable pattern: insert a row of data, scan the contents of an array, query a row for a primary key value, etc.

Wouldn't it be nice if you could simply select the appropriate pattern from a library and then apply it your database objects, generating code that fits your naming conventions, and your application data structures but also automatically follows best practices?

Welcome to the world of QCGU code generation! QCGU takes code generation to a whole new level of flexibility and usability.  We provide a wide range of templates, to which you can add more of your own using our simple Code Generation Markup Language.  Our generation engine lets you easily select your database objects, provide script argument values, and more.

Bottom line: with QCGU code generation, tasks that once took days will take minutes. More

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 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.  More

Powerful search facility with QCGU Explorer

There isn't much point to having hundreds of programs and templates stored in a repository if you can't find what you need.  The QCGU Explorer gives you powerful, flexible search capabilities against the full QCGU repository.

You can search by name, description, abbreviation or GUID.  You can save your favorite searches so that you can quickly return to the set of scripts that interest you most.  And QCGU comes with a number of handy favorites already defined so that PL/SQL developers can quickly find items of interest. More

Built-in error manager for Oracle applications

Every application should implement consistent error handling that communicates information clearly back to the user and also records all necessary information for support and debugging.  Yet how many of us have the time to do this correctly?

To help developers solve this problem once and for all, QCGU offers an error manager that lets you define the error categories and errors in your application definition, raise and handle errors using a pre-defined error package, and analyze errors with the QCGU Runtime Monitor. More

Domain expertise repository

QCGU offers users an extensive library of scripts and templates for PL/SQL and Oracle development, but you are not restricted to using only this content.  You can take advantage of the same Designer used by the QCGU team to build your own libraries.  You might have other ideas for useful Oracle code.  Or you might be working in an entirely different language.  Whatever the language, whatever the requirements, you can store your reusable code and your custom-designed scripts in QCGU. More