PL/SQL Best Practices

PL/SQL Best Practices with Steven Feuerstein Renowned Oracle PL/SQL expert, Steven Feuerstein, presents "PL/SQL Best Practices" -- offering high-level principles to guide our work. Here are some example of the PL/SQL best practices derived from PL_SQL_Best_Practices2.pdf: DEV-01:...

Read More

Database Change Tracking for Oracle

It has often been said that the only constant is change. IT's ability to manage change is an important business success criteria in today's competitive markets. Change can either be planned or unplanned. This presentation will help you understand the effects of change, and how...

Read More

Automating SQL Optimization

Quest® SQL Optimizer for Oracle proactively identifies potential performance issues and automates SQL optimization by scanning and analyzing running SQL statements, PL/SQL, or other source code. * The value of SQL tuning to you and your organization * What the ideal solution looks...

Read More

Common Mistakes in Oracle PL/SQL Programming

I just came a cross this video about oracle pl/sql programming, which provide good technique to write pl/sql code. Very good video to take a look for pl/sql programmer. You wrote an explicit cursor? You declared a variable using the VARCHAR2 datatype? You raised an exception to...

Read More