How to Auto Generate ID on Insert Record Form in Oracle Apex | Mr Gactack

Опубликовано: 14 Май 2026
на канале: Mr Gactack

4,431

Hi guys in this video i am going to show you how to auto generate id on insert record form in Oracle Apex.

Table:-

create table CLASS
(
ID varchar2(50),
CLASS_NAME varchar2(50),
STATUS char(1)
)

Database Trigger:-

CREATE TRIGGER GEN_CLASS
BEFORE
insert on CLASS
for each row
Declare
mVal Number;
Begin
Select nvl(max(to_number(substr(ID,4))),0) + 1 Into mVal From CLASS;
:New.ID := 'CS-'||mVal ;
End;

Oracle Developer , Database , Oracle Apex , Oracle Apex Tutorial , id auto generate from database trigger , auto generate id , step by step , how , how to
--------------
if You enjoy this video please Like and Subscribe!

Channel By: Mr Gactack