Typically this is handled by having a sequence column or similar.

To sort the groups I added a number of spaces infront of each. They are not rendered by the browser.

LPAD(' ', ROW_NUMBER() OVER (ORDER BY {SORT}), ' ') || {VISIBLE_NAME} AS group_name

I'm not sure what the challenge with this is? Just add a sort order based on a column that has a number for the order by

That works for values, but not for groups. Try LOV with groups, they are sorted A-Z and you cant change that…

huh? 

1

2

2.1

2.2

3

10

100.1

100.2….

done

How would you show Meaning before Color if it doesnt starts with a number?

So you're showing indentation there, but still, that sequence column would be ordered by in the List of Values query, and this would be handled easily. The indentation would be a case/when in front of the name (not a whole number) etc..

But the Meaning + Color (the group names) are not part of the query as rows, but as columns. So you cant assign your sequence to the groups. Only to group members. And then you are back to the issue that you cant sort groups.

Here you go, can you show me how would you sort the groups based on this query?

WITH t (group_, name_, value_) AS (
    SELECT 'Color',     'Green',        10 FROM DUAL UNION ALL
    SELECT 'Color',     'Dark Green',   20 FROM DUAL UNION ALL
    SELECT 'Meaning',   'Feature',      30 FROM DUAL UNION ALL
    SELECT 'Meaning',   'Delighter',    40 FROM DUAL
)
SELECT * FROM t;

what am I missing? (or add another column of seq_ similar)

WITH t (group_, name_, value_) AS (
   SELECT 'Color',     'Green',        10  FROM DUAL UNION ALL
   SELECT 'Color',     'Dark Green',   20 FROM DUAL UNION ALL
   SELECT 'Meaning',   'Feature',      30 FROM DUAL UNION ALL
   SELECT 'Meaning',   'Delighter',    40 FROM DUAL
)
SELECT count(*), group_, name_, value_  FROM t
group by  group_, name_, value_
order by value_

Now do this as a source for LOV and try to sort groups as on the screen above. Meaning first, then Color. Try it.

Thanks for the explanation. I concede that it should be easier to achieve what you're after.