See the following example:
SQL>create table t (names varchar(10)); SQL>insert into t values('van Gogh'); SQL>insert into t values('van Damme'); SQL>insert into t values('Janssen'); SQL>insert into t values('Ebermann'); SQL>insert into t values('de Luge'); SQL>-- Normal order using EOR default SQL>select * from t order by names collate eor; NAMES ========== de Luge Ebermann Janssen van Damme van Gogh SQL>-- Customize the EOR default collation SQL>create collation ignore_devan from eor SQL&using '[level 4][alternate shifted]&" "<<<de" "<<<van" "'; SQL>select * from t order by names collate ignore_devan; NAMES ========== van Damme Ebermann van Gogh Janssen de Luge