I want Auto Naming Series just Like IR001 start then user not Create and generate auto Seq IR002,IR003
Share
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
Please explain your question in more detail.
I want auto generate number Ex: Primary key auto number generate.but user want IR001,IR002,IR003 this number series generate auto.
As Sir Suggest You Sequence That’s Good, You Can Also Use ROWNUM With LPAD .
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.