3. How to Add Auto Increment with Sequence and Trigger in Oracle? [ Web App with Oracle Apex ]

In this tutorial, you will learn to add Auto Increment in primary key using Sequence and Trigger.
#WebAppWithOracle #ApexProjectTutorial

This is the Third Episode of our "Web App with Oracle Apex" Tutorial Series.

Sequence - Sequence is a database object from which multiple users may generate unique integers. You can use sequences to automatically generate primary key values.

Triggers - A trigger is a named program unit that is stored in the database and fired (executed) in response to a specified event. The specified event is associated with either a table, a view, a schema, or the database.
It is executed automatically Before/After INSERT, UPDATE or DELETE.

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

FOLLOW ME ON !

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

[rolipoli]

It works on primary key! Thank you very very much!
You're a life saver

[emmysmith]

master nice, step am just at your back learning new things all together

[rajeeshpoozhikkunnath]

I have a general master table for state and city identified by prefix in code 'C' and 'S'. How to generate sequential code with different characters as prefix?

[maha]

if there is any error while entering data sequence will be burned and there is gap found how we can solve this gap

[muhammadismailmehtab]

How add alpha numeric primary key with sequence plz help me

[beastkut]

I got an error .. triggered invalid and failed re validation