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 on “[Oracle APEX 4.0] Clean up sequence numbers

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

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  2. Patrick on said:

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

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
    • Peter van der Neut on said:

      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.

      VN:F [1.9.22_1171]
      Rating: 0 (from 0 votes)

Leave a Reply

Your email address will not be published. Required fields are marked *


* Copy This Password *

* Type Or Paste Password Here *

59,443 Spam Comments Blocked so far by Spam Free Wordpress

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>


Previous post:

Next post:

About Whitehorses
Company profile

Whitehorses website

Home page

Follow us
Blog post RSS
Comment RSS