If you don’t use Oracle’s own NLS sorting function, you can add a Pinyin field to the table, assign the value yourself when inserting the record, and then sort according to the Pinyin field.
This method is less flexible and requires the sorting field to be relatively fixed.
If you don’t use Oracle’s own NLS sorting function, you can add a Pinyin field to the table, assign the value yourself when inserting the record, and then sort according to the Pinyin field.
This method is less flexible and requires the sorting field to be relatively fixed.
Link description
please refer to it