The OCD Table Column Re-Orderer

The OCD Table Column Re-Orderer

Don’t you hate it when you have to add a new column to your carefully handcrafted table and it’s now at the end of the table?
Away from it’s proper and logical place within the other table columns.

Yes?  Well me too.

Enter The OCD Table Column Re-Orderer, a simple APEX application where you can drag & drop your columns to their proper location within a table.

Get it from the repo github.com/rimblas/ocd-table-reorderer

OCD Table Re-Orderer in action
The OCD Table Re-Orderer in action
Schema Switching
Multi-Column Select

I reused a lot of elements from my blog post/video on adding Drag & Drop to your APEX applications. Maybe you’re curious and want to check it out.

UPDATE v2.01 – June 18, 2020:

  • Multi-Column select
  • Switched from jQuery UI Sortable to SortableJS

UPDATE v2.00 – June 14, 2020:

  • Ability to switch between multiple schemas

Hi, I'm Jorge Rimblas. Father, husband, photographer, Oraclenerd, Oracle APEX expert, Oracle ACE, coffee lover, car guy, gadget addict, etc... I'm an APEX Tech Lead DRW. I have worked with Oracle since 1995 and done eBusiness Suite implementations and customizations. Nowadays I specialize almost exclusively in Oracle APEX.

3 Comments on “The OCD Table Column Re-Orderer

  1. Hola Jorge,

    Muy interessante !
    He installado tu application y estoy analizando el paquete..

    Saludos de Berlin,
    Marcus

  2. My wife says that I’m OCD (or perhaps somewhere on the Autism Spectrum) because when things aren’t in their proper places (as defined by how my mind perceives “proper”), it drives me crazy and I tend to obsess over it and devote an entirely unjustified amount of effort toward defeating the offending “whatever.”

    So I completely appreciate this tool because, yes, I hate altering a table to add a column and then finding its order to be “unnatural” (despite the ordering not mattering at all from a relational processing / concepts standpoint).

    Bravo, and thank you for sharing this masterpiece!

I love comments, write me a line