orclz> create index ename_ctx on emp(ename) indextype is ctxsys.context;

Index created.

orclz>
orclz> select * from emp where contains(ename,'{'||'NOR'||'}') >0 ;

no rows selected

orclz>

SCOTT@orcl_12.1.0.2.0> create table test_tab (tt_transvalue  varchar2(30))
  2  /

Table created.

SCOTT@orcl_12.1.0.2.0> insert into test_tab values ('NOR')
  2  /

1 row created.

SCOTT@orcl_12.1.0.2.0> create index test_idx on test_tab (tt_transvalue) indextype is ctxsys.context
  2  /

Index created.

SCOTT@orcl_12.1.0.2.0> select * from test_tab where contains(tt_transvalue,'{'||'NOR'||'}') >0
  2  /

no rows selected

SCOTT@orcl_12.1.0.2.0> drop index test_idx
  2  /

Index dropped.

SCOTT@orcl_12.1.0.2.0> create index test_idx on test_tab (tt_transvalue) indextype is ctxsys.context
  2    parameters ('stoplist ctxsys.empty_stoplist')
  3  /

Index created.

SCOTT@orcl_12.1.0.2.0> select * from test_tab where contains(tt_transvalue,'{'||'NOR'||'}') >0
  2  /

TT_TRANSVALUE
------------------------------
NOR

1 row selected.

SCOTT@orcl_12.1.0.2.0> select spw_word from ctx_stopwords where spw_stoplist = 'DEFAULT_STOPLIST' order by spw_word
  2  /

SPW_WORD
--------------------------------------------------------------------------------
Mr
Mrs
Ms
a
all
almost
also
although
an
and
any
are
as
at
be
because
been
both
but
by
can
could
d
did
do
does
either
for
from
had
has
have
having
he
her
here
hers
him
his
how
however
i
if
in
into
is
it
its
just
ll
me
might
my
no
non
nor
not
of
on
one
only
onto
or
our
ours
s
shall
she
should
since
so
some
still
such
t
than
that
the
their
them
then
there
therefore
these
they
this
those
though
through
thus
to
too
until
ve
very
was
we
were
what
when
where
whether
which
while
who
whose
why
will
with
would
yet
you
your
yours

114 rows selected.