In

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