/ 
DBIO-Oracle-0.900000

Changes for version 0.900000 - 2026-06-23

  • First release. Oracle database driver for DBIO.
  • Storage
    • Oracle storage auto-detected for dbi:Oracle: DSNs, with the -ora shortcut, load_components('Oracle'), and DBIO::Base subclassing
    • Sequence-based auto-increment (auto_nextval / SELECT seq.nextval)
    • LOB binding and chunking for CLOB/NCLOB/BLOB
    • Savepoints, deferrable FK constraint handling, and NLS session setup on connect
    • Pre-9.0 fallback to WHERE-clause joins when ANSI joins are unavailable
  • SQLMaker
    • ROWNUM-based limit/offset via the _RowNum dialect (apply_limit)
    • RETURNING ... INTO ? insert-returning syntax
    • CONNECT BY / START WITH / ORDER SIBLINGS BY / PRIOR hierarchical query support
    • Automatic identifier shortening to Oracle's 30-character limit across SELECT/FROM and WHERE/HAVING paths and relation aliases
  • Deploy
    • Desired-state deployment via test-deploy-and-compare
    • install_ddl creates a fresh schema; upgrade diffs live vs. desired
  • Introspect
    • Native introspection of tables, columns, keys, indexes, and foreign keys via USER_*/ALL_* views
  • Diff
    • Native diff of two introspected models at table, column, and index level
  • DDL
    • Native Oracle DDL generation from DBIO Result classes
    • Dedupe sources sharing a physical table, skip subquery and view sources, dereference literal table names, and emit CREATE VIEW for non-virtual views

Documentation

README.md

Modules

DBIO::Oracle
Oracle-specific schema management for DBIO
DBIO::Oracle::DDL
Generate Oracle DDL from DBIO Result classes
DBIO::Oracle::Deploy
Deploy and upgrade Oracle schemas via test-deploy-and-compare
DBIO::Oracle::Diff
Compare two introspected Oracle models
DBIO::Oracle::Diff::Column
Diff operations for Oracle columns
DBIO::Oracle::Diff::Index
Diff operations for Oracle indexes
DBIO::Oracle::Diff::Table
Diff operations for Oracle tables
DBIO::Oracle::Identifier
Shorten Oracle identifiers to the 30-character limit
DBIO::Oracle::Introspect
Introspect an Oracle database via all_* views
DBIO::Oracle::Introspect::Columns
Introspect Oracle columns
DBIO::Oracle::Introspect::ForeignKeys
Introspect Oracle foreign keys
DBIO::Oracle::Introspect::Indexes
Introspect Oracle indexes
DBIO::Oracle::Introspect::Keys
Introspect Oracle primary key and unique constraints
DBIO::Oracle::Introspect::Tables
Introspect Oracle tables and views
DBIO::Oracle::SQLMaker
Oracle-specific SQL generation for DBIO
DBIO::Oracle::SQLMaker::Joins
Pre-ANSI Joins-via-Where-Clause Syntax for Oracle
DBIO::Oracle::Storage
Oracle Support for DBIO
DBIO::Oracle::Storage::AutoIncrement
Auto-increment / sequence detection for Oracle
DBIO::Oracle::Storage::ConnectSetup
Oracle session NLS setup on connect
DBIO::Oracle::Storage::FKDeferral
FK constraint deferral for Oracle
DBIO::Oracle::Storage::LOBSupport
LOB binding and chunking for Oracle
DBIO::Oracle::Storage::Savepoints
Savepoint management for Oracle
DBIO::Oracle::Storage::WhereJoins
Oracle joins in WHERE syntax support (instead of ANSI).
DBIO::Oracle::Test::SequenceTest
Test result class for Oracle sequence tests
DBIO::Oracle::Type
Oracle type mapping utilities
DBIO::Shortcut::ora
`use DBIO -ora` shortcut for the Oracle driver

Other files