What problem does it solve? Working with Oracle Database requires knowing its specific conventions that differ from other databases, such as using VARCHAR2 instead of VARCHAR, choosing between IDENTITY columns and sequences, and writing correct PL/SQL. This Skill gives you a complete reference of Oracle-specific best practices so you avoid common mistakes and write idiomatic, performant database code. ## Core Features & Use Cases - Data Type & Schema Guidance: Covers VARCHAR2, NUMBER precision for currency, DATE vs TIMESTAMP, CLOB/BLOB, and JSON columns with correct CREATE TABLE patterns. - PL/SQL & Sequences: Provides templates for stored procedures, functions, packages, triggers, IDENTITY columns, and bulk operations with FORALL and BULK COLLECT. - Performance & Administration: Explains partitioning strategies (range, list, hash), optimizer hints, DBMS_STATS statistics gathering, and tablespace management. - Use Case: When building a Spring Boot application backed by Oracle, use this Skill to generate a correctly typed JPA entity, configure HikariCP for Oracle, and write a partitioned orders table with proper indexes. ## Quick Start Ask the AI to design an Oracle table schema with proper data types, an IDENTITY primary key, and range partitioning for a high-volume orders table.
