laravel-oci8

laravel-oci8 copied to clipboard

Materialized view

2

### Materialized view with the package How do I run this materialized view with the package? - It works ``` $conn = oci_pconnect("user", "pass", "127.0.0.1/XE"); $sql = oci_parse($conn, "BEGIN DBMS_MVIEW.REFRESH('MV_DW_TESTE');...

luiz-andrade

FullText Search in laravel-oci8

5

**Title 😎** Hello, this pull request implements the "whereFullText()" method for laravel/oci8. **Description 🤯** The implementation utilizes the CONTAINS Oracle feature to perform a text search using the ctxsys.context index....

jonas-elias

Cannot use sequences not owned by DB user

1

### Summary of problem or feature request Hi, I cannot drop or get the current value of sequences that my user is not the owner of, even though my user...

striker4150

$model->replicate() fails because of row number

1

### Summary of problem or feature request Replicating and saving a new model fails as it tries to insert into the `rn` column which doesn't exist. ### Code snippet of...

nmalcolm

Implement insertOrIgnore

1

### Summary of problem or feature request Oracle doesn't support a syntax such as `INSERT IGNORE` but since 11g there's a `ignore_row_on_dupkey_index` hint. I've tried to implement it myself but...

nmalcolm

Errors when trying to query tables with lower cased names

2

### Summary of problem or feature request The database I'm trying to connect to has a table named like this: `"vwInt_dimProject"`. When I try to query this table with the...

BARNZ

Disabling foreign key constraints

1

Hi it's me again this pr is for adding the following missing method ``` compileEnableForeignKeyConstraints compileDisableForeignKeyConstraints ``` this pr close the following issue too https://github.com/yajra/laravel-oci8/issues/488

ErDiabIo

### Summary of problem or feature request I can't connect to orcale database with laravel .It gives me this error :[ oci_connect(): ORA-12154: TNS:could not resolve the connect identifier specified]...

amira95ibrahim

feat: improve pagination performance

15

Improve pagination performance by using ROW_NUMBER() and handling default orders. fix: #878, #870 test: pagination improvement SQL changes fix: subSelect where in query fix: pagination when using fromSub

yajra

fix yajra#882 - Due to conflict previous changes were reverted, synchronized repo.

3

Due to conflict previous changes were reverted, synchronized repo. fix yajra#882

Sudheert7