Oracle Database 11g introduced a new feature called PL/Scope. A while back, I wrote about Dan Morgan’s experience when he compiled the package STANDARD for PL/Scope. I also wrote about Oracle’s answer, in which they said “…the reason to compile STANDARD would be to make its identifiers available in the new DBA_Identifiers view family (see […]
In addition to Oracle Mix, Oracle Wiki and Oracle Community, OAUG will be launching yet another Oracle related social network called the Knowledge Factory.
The Knowledge Factory will provide a platform for users to exchange ideas, experiences, and expertise within the Oracle Applications member community. It will feature user profiles with pictures and biographies, blogs, forums […]
The document below contains patterns of bad SQL and PL/SQL code that Gojko Adzic has repeatedly found in various applications and databases. Some of the bad practices include:
Use of WHEN OTHERS in exception handling.
Embedding complex SQL inside PL/SQL code.
Poor PL/SQL error handling.
Hardcoding the size of PL/SQL variables.
Not using bind variables.
Storing ROWIDs for later reference.
Storing […]