Follow Us on Twitter

[Oracle APEX 4.0] Clean up sequence numbers

by Peter van der Neut on January 27, 2010 · 3 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: , ,

{ 3 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.


Leave a Comment


Previous post:

Next post:

About Whitehorses
Company profile

Whitehorses website

Home page

Follow us
Blog post RSS
Comment RSS