ODBC Script ( Oracle Connection String )

 Driver={Oracle in OraClient11g_home2};Dbq=orcl;Uid=kami;Pwd=kami;

Increment ItemCode Using Java Script in Intrective Grid

 (function() {

    var grid = apex.region("myGrid").widget().interactiveGrid("getViews", "grid"),

        model = grid.model,

        rowNum = 0,

        p16CatId = $v("P16_CAT_ID"); // Get the value of P16_CAT_ID

    model.forEach(function(record, index) {

        rowNum++;

        var rowNumStr = rowNum.toString().padStart(5, '0'); // Ensure rowNum is 5 digits with leading zeros

        var pls = p16CatId + rowNumStr; // Concatenate P16_CAT_ID and the formatted rowNum

        model.setValue(record, "ICODE", pls);

    });

})();

-----------------------------------------------------------------------------------------------------------------------------

// (function() {

//     var grid = apex.region("myGrid").widget().interactiveGrid("getViews", "grid"),

//         model = grid.model,

//         rowNum = 0;

//     model.forEach(function(record, index) {

//         rowNum++;

//          model.setValue(record, "ICODE", rowNum.toString());

//     });

// })();