SQL "like" operator does not work properly on x$ fixed views

From: Don Burleson <don_at_burleson.cc>
Date: 14 Aug 2002 04:23:12 -0700
Message-ID: <998d28f7.0208140323.607e732f@posting.google.com>

Can anyone explain this apparent SQL bug? The "like" filter seems to ignore the underscores when querying the x$ fixed tables:

select ksppinm from x$ksppi where ksppinm like '%_io_%';

KSPPINM

---

sessions
license_max_sessions
license_sessions_warning
_session_idle_bit_latches
_enable_NUMA_optimization

java_soft_sessionspace_limit
java_max_sessionspace_size
_trace_options
_io_slaves_disabled

dbwr_io_slaves
_lgwr_io_slaves
Received on Wed Aug 14 2002 - 06:23:12 CDT