Skills
.Work. You
Rest

oracle-plus-join-rewriter

Community

Rewrite Oracle (+) joins to ANSI safely.

Software Engineering#sql#oracle#risk-analysis#rewrite#join#ansi-join
AuthorSukiEva
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Rewrite Oracle legacy outer join syntax that uses (+) into standard ANSI JOIN SQL, and convert comma-style joins to explicit INNER JOIN when that can be proven not to change the result set, while preserving unchanged text outside the rewritten join-related clauses. Use when the user provides Oracle SQL containing (+), comma joins in FROM, wants a standards-compliant rewrite, wants only the necessary join-related edits, or needs a safety review for whether the rewrite could change the result set.

Core Features & Use Cases

  • Rewrites legacy Oracle outer joins that use (+) into ANSI JOIN syntax, clarifying join direction.
  • Converts safe comma-style inner joins to explicit INNER JOIN when the overall result set remains the same.
  • Preserves non-join text, aliases, hints, and the broader query structure while applying join-related edits.
  • Performs risk checks and flags cases that require business confirmation before finalizing changes.

Quick Start

Provide a sample Oracle SQL containing (+) or comma-style joins in FROM, and I will generate an ANSI JOIN version with minimal, join-focused edits.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: oracle-plus-join-rewriter
Download link: https://github.com/SukiEva/AgentSkills/archive/main.zip#oracle-plus-join-rewriter

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.