PHPackages                             dayatdev/laravel-oracle-sequence - 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. [Database & ORM](/categories/database)
4. /
5. dayatdev/laravel-oracle-sequence

ActiveLibrary[Database & ORM](/categories/database)

dayatdev/laravel-oracle-sequence
================================

A Laravel package to handle Oracle SEQUENCE operations (auto NEXTVAL and sequence creation) easily.

00PHP

Since Nov 10Pushed 6mo agoCompare

[ Source](https://github.com/m-hidayatullahh/laravel-oracle-sequence)[ Packagist](https://packagist.org/packages/dayatdev/laravel-oracle-sequence)[ RSS](/packages/dayatdev-laravel-oracle-sequence/feed)WikiDiscussions main Synced 1mo ago

READMEChangelogDependenciesVersions (1)Used By (0)

Laravel Oracle Sequence
=======================

[](#laravel-oracle-sequence)

[![Latest Version on Packagist](https://camo.githubusercontent.com/2899cd94308a47067e0794d6713760b53a8aadcd8113fec8addee38042d23b65/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f762f64617961746465762f6c61726176656c2d6f7261636c652d73657175656e63652e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/dayatdev/laravel-oracle-sequence)[![Total Downloads](https://camo.githubusercontent.com/7ac30a5ccb0df5a83e71054cfbbc1952cce182e72f0c1a52818192d833d858af/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f64617961746465762f6c61726176656c2d6f7261636c652d73657175656e63652e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/dayatdev/laravel-oracle-sequence)

> 🔁 Library Laravel untuk menangani **Oracle SEQUENCE** seperti `NEXTVAL` / `CURRVAL`, agar tidak error setelah migrasi atau saat insert data tanpa auto increment bawaan.

Package ini memungkinkan kamu:

- Membuat sequence otomatis jika belum ada di database Oracle.
- Mengambil nilai berikut (`NEXTVAL`) dari sequence.
- Integrasi langsung dengan Eloquent model via trait.
- Gunakan pada project Laravel biasa tanpa konfigurasi tambahan yang rumit.

---

🧩 Requirements
--------------

[](#-requirements)

KomponenVersi MinimumPHP8.1Laravel9.x, 10.x, 11.xDatabaseOracle (tested on 12c, 19c)PDO Driver`pdo_oci` atau `yajra/laravel-oci8`---

⚙️ Installation
---------------

[](#️-installation)

```
composer require dayatdev/laravel-oracle-sequence
```

Setup
-----

[](#setup)

```
//config/app.php
'providers' => [
    DayatDev\OracleSequence\OracleSequenceServiceProvider::class,
],
'aliases' => [
    'OracleSequence' => DayatDev\OracleSequence\Facades\OracleSequence::class,
],
```

Clear cache & autoload
--------------------------

[](#clear-cache--autoload)

```
php artisan config:clear
composer dump-autoload
```

Usage
-----

[](#usage)

1. Mengambil next value dari sequence

```
use DayatDev\OracleSequence\Facades\OracleSequence;

$nextVal = OracleSequence::nextval('USER_SEQ');

echo $nextVal;
```

Jika sequence belum ada, package otomatis akan membuat:

```
CREATE SEQUENCE USER_SEQ START WITH 1 INCREMENT BY 1 NOCACHE;
```

2.Menggunakan pada Model Eloquent

```
namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use DayatDev\OracleSequence\Traits\HasOracleSequence;

class Banner extends Model
{
    use HasOracleSequence;

    protected $table = 'banners';
    protected $primaryKey = 'id';
    public $incrementing = false; // wajib false jika bukan auto increment DB

    // opsional: override nama sequence
    protected string $sequenceName = 'BANNERS_SEQ';
}
```

3.Mengambil nilai sequence tanpa insert

```
```

###  Health Score

17

—

LowBetter than 6% of packages

Maintenance47

Moderate activity, may be stable

Popularity0

Limited adoption so far

Community6

Small or concentrated contributor base

Maturity13

Early-stage or recently created project

 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.

### Community

Maintainers

![](https://www.gravatar.com/avatar/ce4b4e56803364af50984a4ee0fce10dafed54374010eb7f2e29b1c9dafb2edc?d=identicon)[m-hidayatullahh](/maintainers/m-hidayatullahh)

---

Top Contributors

[![m-hidayatullahh](https://avatars.githubusercontent.com/u/184669567?v=4)](https://github.com/m-hidayatullahh "m-hidayatullahh (1 commits)")

### Embed Badge

![Health badge](/badges/dayatdev-laravel-oracle-sequence/health.svg)

```
[![Health](https://phpackages.com/badges/dayatdev-laravel-oracle-sequence/health.svg)](https://phpackages.com/packages/dayatdev-laravel-oracle-sequence)
```

###  Alternatives

[doctrine/orm

Object-Relational-Mapper for PHP

10.2k285.3M6.2k](/packages/doctrine-orm)[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k115.1M102](/packages/jdorn-sql-formatter)[illuminate/database

The Illuminate Database package.

2.8k52.4M9.4k](/packages/illuminate-database)[ramsey/uuid-doctrine

Use ramsey/uuid as a Doctrine field type.

90440.3M211](/packages/ramsey-uuid-doctrine)[reliese/laravel

Reliese Components for Laravel Framework code generation.

1.7k3.4M16](/packages/reliese-laravel)[wildside/userstamps

Laravel Userstamps provides an Eloquent trait which automatically maintains `created\_by` and `updated\_by` columns on your model, populated by the currently authenticated user in your application.

7511.7M13](/packages/wildside-userstamps)

PHPackages © 2026

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