Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to compare 2 APEX multi-select/shuttle box lists (e.g.1:2:3 and 3:1:2) for equality?

PPlattSep 12 2013 — edited Sep 16 2013

I want to validate 2 shuttle list selections for equality. for example

1:2:5:7:18:3

and

1:5:7:2:3:18

should be treated as equal and therefore valid(i.e. same selections but in different order)

while

1:2:5:7:18:3

and

1:2:18:9 are not equal and would fail validation.

If I use string_to_table() function on both lists then I would need to sort the associative arrays and then compare them for equality.  Any suggestions on how best to do this?

thanks in advance

PaulP

This post has been answered by PPlatt on Sep 16 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 14 2013
Added on Sep 12 2013
7 comments
1,148 views