oracle

Oracle Database with PL/SQL, RAC, and enterprise features. Use for enterprise systems.

7 stars

byG1Joshi

View on GitHub Installation ↓

Best use case

oracle is best used when you need a repeatable AI agent workflow instead of a one-off prompt.

Oracle Database with PL/SQL, RAC, and enterprise features. Use for enterprise systems.

Teams using oracle should expect a more consistent output, faster repeated execution, less prompt rewriting.

When to use this skill

You want a reusable workflow that can be run more than once with consistent structure.

When not to use this skill

You only need a quick one-off answer and do not need a reusable workflow.
You cannot install or maintain the underlying files, dependencies, or repository context.

Installation

Claude Code / Cursor / Codex

$curl -o ~/.claude/skills/oracle/SKILL.md --create-dirs "https://raw.githubusercontent.com/G1Joshi/Agent-Skills/main/skills/databases/oracle/SKILL.md"

Manual Installation

Download SKILL.md from GitHub
Place it in .claude/skills/oracle/SKILL.md inside your project
Restart your AI agent — it will auto-discover the skill

How oracle Compares

Feature / Agent	oracle	Standard Approach
Platform Support	Not specified	Limited / Varies
Context Awareness	High	Baseline
Installation Complexity	Unknown	N/A

Frequently Asked Questions

What does this skill do?

Oracle Database with PL/SQL, RAC, and enterprise features. Use for enterprise systems.

Where can I find the source code?

You can find the source code on GitHub using the link provided at the top of the page.

SKILL.md Source

# Oracle Database

Oracle Database is a multi-model database management system. It is the de-facto standard for Fortune 500 mission-critical systems due to its reliability, scalability (RAC), and PL/SQL power.

## When to Use

- **Mission Critical**: Banking, Airlines, Telecoms where 99.999% uptime is required.
- **PL/SQL**: When you have massive business logic that needs to run close to the data.
- **Complex Workloads**: OLTP and OLAP in the same DB.

## Quick Start

```sql
-- Implicit cursor loop in PL/SQL
BEGIN
  FOR r IN (SELECT first_name, last_name FROM employees WHERE department_id = 10)
  LOOP
    DBMS_OUTPUT.PUT_LINE(r.first_name || ' ' || r.last_name);
  END LOOP;
END;
/
```

## Core Concepts

### PL/SQL

Procedural Language/SQL. Extremely mature and powerful language stored within the DB.

### RAC (Real Application Clusters)

Allows multiple servers to access the same database storage simultaneously. If one server fails, the others keep running (High Availability).

### Multi-Tenant (CDB/PDB)

One Container Database (CDB) hosts multiple Pluggable Databases (PDBs). Efficient resource sharing.

## Best Practices (2025)

**Do**:

- **Use Oracle 23ai**: Leverage "JSON Relational Duality" to view the same data as both Tables and JSON Documents simultaneously.
- **Use Tuning Advisor**: Oracle's automated tuning tools are excellent.
- **Use Flashback**: Query data "as of" a timestamp in the past to recover from accidental logical errors.

**Don't**:

- **Don't commit in loops**: It kills IO. Commit once at the end.
- **Don't treat it like MySQL**: Oracle's architecture (Redo, Undo, Shared Pool) is heavier and requires specific tuning.

## References

- [Oracle Database 23ai Documentation](https://docs.oracle.com/en/database/oracle/oracle-database/)