How to update oracle table using laravel eloquent query

With knowing that eloquent converts to regular sql at run time anyway, why not just use normal queries. Just my 2 cents.

@JLRDW - I need to put it inside controller...

I haven't messed with oracle for years, and when I did it was coldfusion I programmed in.

I had to write code to calc pagination. Does modern oracle have any type LIMIT, OFFSET clause yet.

I know sql server 2014 has that now. Now you have me curious.

You can still return results from a model, or use VC, much like some did with java, just a view and servlet. Depends on how large app is and the section of app in question.

New asp.net razor has just MV. Model and controller combined. It's pretty good.

@JLRDW - I'm too novice with laravel and eloquent. I'll try to do it with normal query (I guess using DB::raw)...

DB::raw)...

Bind your parameters, give me second I am putting up some links, but may not work with oracle.

https://laracasts.com/discuss/channels/guides/getpdo-usage

https://laracasts.com/discuss/channels/eloquent/writing-all-queries-directly-vs-model-relations

https://laracasts.com/discuss/channels/laravel/sql-native-to-query-builder //Long query example

https://laracasts.com/discuss/channels/laravel/coverting-ms-access-queries-to-laravel-query-builder

https://laracasts.com/discuss/channels/general-discussion/sql-injection-2

https://www.yiiframework.com/wiki/2541/when-to-use-active-record

My solution that worked is this. In fact I populated table with all PR_INDEX values set to 1 by default and zeroed them conditionally. The function editor is inside controller obviously.

@jlrdw Thanks a lot for your resources!

public function editor (Request $ppp) { $pppvar = $ppp -> get('identity');

    DB::table('prog_title')
        ->where('pr_id', $pppvar)
        ->update(array('pr_index' => 0));
        
    return view ('return'); 

}