PHPackages                             iayoo/think-oracle - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. iayoo/think-oracle

ActiveLibrary

iayoo/think-oracle
==================

thinkphp 6.0 的oracle扩展

v1.1.4(4y ago)119MITPHPPHP >=7.1.0

Since May 19Pushed 4y ago1 watchersCompare

[ Source](https://github.com/iayoo/think-oracle)[ Packagist](https://packagist.org/packages/iayoo/think-oracle)[ RSS](/packages/iayoo-think-oracle/feed)WikiDiscussions 1.0 Synced 2d ago

READMEChangelog (4)Dependencies (2)Versions (7)Used By (0)

think-oracle
============

[](#think-oracle)

基于官方库 `think-oracle` 上做了一些兼容修改。 使用了 `oracle-19c` 的数据库版本进行测试，其它版本尚未测试。

如果有问题可以提 `issue` .

依赖
--

[](#依赖)

- thinkphp 6.0
- think-orm 2.0 及以上
- php 7.1 及以上

安装
--

[](#安装)

```
composer require iayoo/think-oracle

```

打开 `config/database.php` 配置文件 , 在 `connections` 参数下新增以下内容

```
'oracle' => [
    // 数据库类型
    'type'            => env('oracle.type', '\iayoo\think\Oracle'),
    // 服务器地址
    'hostname'        => env('oracle.hostname', '127.0.0.1'),
    // 数据库名
    'database'        => env('oracle.database', ''),
    // 用户名
    'username'        => env('oracle.username', ''),
    // 密码
    'password'        => env('oracle.password', ''),
    // 端口
    'hostport'        => env('oracle.hostport', '1521'),
    // 数据库连接参数
    'params'          => [],
    // 数据库编码默认采用utf8
    'charset'         => env('database.charset', 'utf8'),
    // 数据库表前缀
    'prefix'          => env('database.prefix', ''),

    // 数据库部署方式:0 集中式(单一服务器),1 分布式(主从服务器)
    'deploy'          => 0,
    // 数据库读写是否分离 主从式有效
    'rw_separate'     => false,
    // 读写分离后 主服务器数量
    'master_num'      => 1,
    // 指定从服务器序号
    'slave_no'        => '',
    // 是否严格检查字段是否存在
    'fields_strict'   => true,
    // 是否需要断线重连
    'break_reconnect' => false,
    // 监听SQL
    'trigger_sql'     => env('app_debug', true),
    // 开启字段缓存
    'fields_cache'    => false,
    // Builder类
    'builder'         => 'iayoo\think\Builder',
    // Query类
    'query'           => 'iayoo\think\Query',
]
```

然后进入环境配置文件中 `.env` 下，新增以下内容

```
[DATABASE]
DRIVER = oracle
PREFIX = 你的数据库表前缀

[ORACLE]
HOSTNAME = 数据库地址
DATABASE = 数据库SID
USERNAME = 数据库用户名
PASSWORD = 数据库密码
PREFIX = 表前缀
HOSTPORT = 端口号
CHARSET = utf8
DEBUG = false
SEQ_PRE= 自增序列前缀

```

修改说明
----

[](#修改说明)

- `Builer` 库重写，对查询字段新增双引号`"`，适应小写的字段和表问题
- `自增主键` 问题使用原生查询兼容，配合 `触发器` 和 `序列` 实现 `自增ID`
- `insertAll` 方法的重写，由于官方扩展中没有实现 `insertAll` ，所以自行实现了一次
- `count` 方法的适配，由于原有的 `count` 不适配 `Oracle` 的语法，因此该方法重新实现了一次
- 语法解析方法基本都适配了 `Oracle-19c` 的语法，其中包含 `insert`,`parseData`,`parseDuplicate`,`insertAll`,`parseField`,`parseKey`

###  Health Score

24

—

LowBetter than 32% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity8

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity51

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~0 days

Total

6

Last Release

1820d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/28df4c2b32e952b2e8111a2a8d527193e496ef05f467c83475c502b17764e5cd?d=identicon)[iayoo](/maintainers/iayoo)

---

Top Contributors

[![iayoo](https://avatars.githubusercontent.com/u/29270812?v=4)](https://github.com/iayoo "iayoo (9 commits)")

---

Tags

pdooraclepdo\_ocithinkphpocithinkphp6topthinkthihnkphp5think-oracle

### Embed Badge

![Health badge](/badges/iayoo-think-oracle/health.svg)

```
[![Health](https://phpackages.com/badges/iayoo-think-oracle/health.svg)](https://phpackages.com/packages/iayoo-think-oracle)
```

###  Alternatives

[doctrine/dbal

Powerful PHP database abstraction layer (DBAL) with many features for database schema introspection and management.

9.7k578.4M5.6k](/packages/doctrine-dbal)[yajra/laravel-oci8

Oracle DB driver for Laravel via OCI8

8703.0M17](/packages/yajra-laravel-oci8)[nette/database

💾 Nette Database: layer with a familiar PDO-like API but much more powerful. Building queries, advanced joins, drivers for MySQL, PostgreSQL, SQLite, MS SQL Server and Oracle.

5656.7M234](/packages/nette-database)[taq/pdooci

Replacement for the PHP PDO OCI class

67144.0k1](/packages/taq-pdooci)[tommyknocker/pdo-database-class

Framework-agnostic PHP database library with unified API for MySQL, MariaDB, PostgreSQL, SQLite, MSSQL, and Oracle. Query Builder, caching, sharding, window functions, CTEs, JSON, migrations, ActiveRecord, CLI tools, AI-powered analysis. Zero external dependencies.

845.7k](/packages/tommyknocker-pdo-database-class)[nhzex/think-phinx

Phinx integration for thinkphp

243.1k](/packages/nhzex-think-phinx)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)