Zulqarnain Haider 4 Questions 6 Answers 0 Best Answers 47 Points View Profile1 Zulqarnain HaiderContributor Asked: September 2, 20202020-09-02T13:46:29+05:30 2020-09-02T13:46:29+05:30Oracle Apex Auto Naming Series Like IR0011I want Auto Naming Series just Like IR001 start then user not Create and generate auto Seq IR002,IR003 autonamingseries4 AnswersVinish 1 Question 325 Answers 28 Best Answers 1k Points View Profile Vinish Legendary 2020-09-02T14:04:31+05:30Added an answer on September 2, 2020 at 2:04 pm Please explain your question in more detail.0 Share ShareShare on FacebookShare on TwitterZulqarnain Haider 4 Questions 6 Answers 0 Best Answers 47 Points View Profile Zulqarnain Contributor 2020-09-02T15:52:59+05:30Replied to answer on September 2, 2020 at 3:52 pm This answer was edited. I want auto generate number Ex: Primary key auto number generate.but user want IR001,IR002,IR003 this number series generate auto. 1 Share ShareShare on FacebookShare on TwitterVinish 1 Question 325 Answers 28 Best Answers 1k Points View ProfileBest Answer Vinish Legendary 2020-09-02T16:07:49+05:30Replied to answer on September 2, 2020 at 4:07 pm Ok to do this, follow these steps:Create a sequence object in the database, for example:Create sequence seq_mypk start with 1 increment by 1 order nocache;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:Select 'IR00'||seq_mypk.nextval from dualor use the following method:2. Create a trigger on your table for before insert and assign the value as shown in the below example::new.mypk := 'IR00'||seq_mypk.nextval;Let me know if any questions.Please if an answer resolves your issue, then please close it by choosing the best answer option.0 Share ShareShare on FacebookShare on TwitterFarooq Ahmad Lahore, Pakistan 16 Questions 22 Answers 0 Best Answers 172 Points View Profile Farooq Ahmad Professional 2020-09-07T01:51:18+05:30Replied to answer on September 7, 2020 at 1:51 am As Sir Suggest You Sequence That’s Good, You Can Also Use ROWNUM With LPAD .1 Share ShareShare on FacebookShare on TwitterYou must login to add an answer. Username or email* Password* Captcha* Click on image to update the captcha. Remember Me! Forgot Password?