I want Auto Naming Series just Like IR001 start then user not Create and generate auto Seq IR002,IR003
❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
Vinish Kapoor
Please explain your question in more detail.
Zulqarnain Haider
I want auto generate number Ex: Primary key auto number generate.but user want IR001,IR002,IR003 this number series generate auto.
Vinish Kapoor
Ok to do this, follow these steps:
Create a sequence object in the database, for example:
Now using two ways you can assign the value to your primary key column:
1. In Oracle Apex page, click on your primary key column and set the default value as the following SQL query:
or use the following method:
2. Create a trigger on your table for before insert and assign the value as shown in the below example:
Let me know if any questions.
Please if an answer resolves your issue, then please close it by choosing the best answer option.
Farooq Ahmad
As Sir Suggest You Sequence That's Good, You Can Also Use ROWNUM With LPAD .