Oracle Code Review Guide

Review Priorities

• Query correctness and readability.
• Parameterized SQL and injection safety.
• Transaction boundaries and rollback strategy.
• Query plan awareness for heavy operations.

Checklist

• Are bind variables used where needed?
• Are exceptions handled meaningfully?
• Are indexes aligned with query predicates?
• Is transaction scope minimal and safe?

Summary

Review SQL/PLSQL with both correctness and scale in mind.