[Solved] Oracle SQL how to sort data inside a row [closed]

Question

Just query the row then process it in java.

The easiest would be:

String[] data = row.split("\\|");
Arrays.sort(data);

Depending on exactly how you want it sorted you will probably need to define a custom comparator for the sort.

Accepted Answer

Just query the row then process it in java.

The easiest would be:

String[] data = row.split("\\|");
Arrays.sort(data);

Depending on exactly how you want it sorted you will probably need to define a custom comparator for the sort.