oracle

When to use this skill

Use this skill whenever the user wants to:

• Write Oracle SQL or PL/SQL (stored procedures, functions, triggers, packages)
• Design tables, indexes, partitions, or constraints in Oracle
• Tune query performance with EXPLAIN PLAN, AWR, or ASH reports
• Manage Oracle administration (users, roles, tablespaces, RMAN backup)
• Configure RAC, Data Guard, or Oracle replication

How to use this skill

Workflow

1. Identify the task - SQL writing, PL/SQL development, performance tuning, or DBA operations
2. Write the code - Use the patterns below matching Oracle syntax
3. Analyze performance - Run EXPLAIN PLAN or review AWR snapshots
4. Apply Oracle-specific best practices - Bind variables, partitioning, RMAN

Quick-Start Example: PL/SQL Procedure with Error Handling