How to Generate Serial Number in Oracle Forms?

 

Step 1:

First and foremost, develop a tabular form. EMP was developed by myself in this particular instance. Form a tabular table of contents.

Step 2:

Create a text field with the name Sno in the title.

Step 3:

Navigate to the property palette by selecting the SNO. F4 is the shortcut key for the property palette.

Step 4:

Scroll down or search Database item and set it to No.

Step 5:

Now we'll move on to the block level. Additionally, Create WHEN-CREATE-RECORD and POST-QUERY Triggers.

Step 6:

To use both triggers, you must copy and paste the same code.

:emp.sno := :system.trigger_record;

Output:

If you have any problem so download the file to click on "Download".

Download

 I hope it's helpful for you. If you have any queries, don't hesitate to contact me.

Name : Muhammad Sahal Qasim

E-mail : s.m.sahal789@gmail.com

Thank you.