Implement Oracle Database Provider

[cevheri]

Title: feat: Add Oracle database provider support

Overview

Implement a new Oracle database provider following the same Strategy Pattern as PostgreSQL. Oracle has specific SQL syntax and features that need to be handled.

Requirements

• Implement OracleProvider class extending SQLBaseProvider
• Support Oracle-specific connection parameters
• Handle Oracle SQL syntax differences
• Implement schema introspection for Oracle
• Add Oracle-specific monitoring queries

Tasks

• Create src/lib/db/providers/sql/oracle.ts
• Add oracledb npm package dependency
• Implement connection and pooling
• Implement getSchema() with Oracle system tables
• Implement getHealth() and monitoring features
• Handle Oracle-specific data types
• Add Oracle to factory (src/lib/db/factory.ts)
• Add Oracle to types (src/lib/types.ts)
• Test with Oracle 12c, 19c, 21c+
• Document Oracle connection requirements

Dependencies

{
  "oracledb": "^6.0.0"
}

Acceptance Criteria

• Oracle provider follows same interface as PostgreSQL
• Connection works with Oracle 12c+
• Schema introspection returns accurate table/column info
• Monitoring features work correctly
• Error handling is user-friendly

References

• Oracle Node.js Driver
• Base class: src/lib/db/providers/sql/sql-base.ts