Follow Us on Twitter

[Oracle APEX 4.0] Clean up sequence numbers

by Peter van der Neut on January 27, 2010 · 4 comments

Once in a while my sequence numbers for items on a page end up being consecutive. Adding an item after that means editing the items and changing the sequence number, not a very pleasant job. Like in the following situation:

If I want to add an item between P7_CUST_LAST_NAME and P7_CUST_STREET_ADDRESS1, I have to edit the sequence of both P7_CUST_STREET_ADDRESS1 and P7_CUST_STREET_ADDRESS2 before I can add this new item.

APEX 4.0 has a nice new feature to clean up those sequence numbers. It’s under the Utilities option on top of the page.

When running this cleanup, a confirmation page is shown.

After running this sequence clean up, we get the following result for our items on the page:

As you can see the sequence numbers have been cleaned up with increments of 10! This example shows the clean up for items on a page, but this feature cleans up all page components (regions, buttons and processes etc.).

[Oracle APEX 4.0] Clean up sequence numbers, 5.0 out of 5 based on 2 ratings
VN:F [1.9.22_1171]
Rating: 5.0/5 (2 votes cast)
Tags: , ,

{ 4 comments… read them below or add one }

Michel van Zoest January 27, 2010 at 12:17 pm

Cool feature!
Could have used that one in some of my APEX 3.x projects. This is a great time-saver.


Patrick January 27, 2010 at 12:31 pm

nice feature indeed. Is it possible to modify the increment to, say, 20 or 50?


Peter van der Neut January 27, 2010 at 12:49 pm

By the looks of it, it’s not possible to change the increment. I’ve suggested this in the feedback, so maybe they will add it.


Jawad September 28, 2015 at 8:16 am

I have a question, i am working in Oracle APEX 5, i was working fine in this, now when i am trying to add a column in query in interactive reporting OR creating a new region it gives me few errors i.e. Region sequence must be numeric, item sequence must be numeric, width must be numeric, height must be numeric. Please provide solution for this issue.


Leave a Comment


Previous post:

Next post:

About Whitehorses
Company profile

Whitehorses website

Home page

Follow us
Blog post RSS
Comment RSS