如何修改oracle默认的通配符？？？

[cranberry]

想让"_"在oracle中不作为通配符使用，应该如何修改oracle的配置阿？

[biti_rainy]

没有配置可改

你可以在语句中：

SQL> select *from t where sno like '_%' escape '_';

未选定行


Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE
1 0 TABLE ACCESS (BY INDEX ROWID) OF 'T'
2 1 INDEX (RANGE SCAN) OF 'T1' (NON-UNIQUE)




Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
1 consistent gets
0 physical reads
0 redo size
308 bytes sent via SQL*Net to client
314 bytes received via SQL*Net from client
1 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
0 rows processed

SQL> select *from t where sno like '_%' ;

SNO GRADE ADDRESS
---------- ---------- --------------------------------------------------
20 97215 珠海翠香路松林街2号7栋101
6 97217 珠海翠香路松林街2号7栋101
7 97219 珠海翠香路松林街2号7栋101
8 97221 珠海翠香路松林街2号7栋101
10 97229 珠海翠香路松林街2号7栋101
20 97215 珠海翠香路松林街2号7栋101
6 97217 珠海翠香路松林街2号7栋101
7 97219 珠海翠香路松林街2号7栋101
8 97221 珠海翠香路松林街2号7栋101
8 97223 珠海翠香路松林街2号7栋101
8 97225 珠海翠香路松林街2号7栋101

SNO GRADE ADDRESS
---------- ---------- --------------------------------------------------
9 97227 珠海翠香路松林街2号7栋101
10 97229 珠海翠香路松林街2号7栋101
20 97215 珠海翠香路松林街2号7栋101
6 97217 珠海翠香路松林街2号7栋101
7 97219 珠海翠香路松林街2号7栋101
8 97221 珠海翠香路松林街2号7栋101
8 97223 珠海翠香路松林街2号7栋101
8 97225 珠海翠香路松林街2号7栋101
9 97227 珠海翠香路松林街2号7栋101

已选择20行。


Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE
1 0 TABLE ACCESS (FULL) OF 'T'




Statistics
----------------------------------------------------------
0 recursive calls
12 db block gets
7 consistent gets
0 physical reads
0 redo size
1504 bytes sent via SQL*Net to client
536 bytes received via SQL*Net from client
3 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
20 rows processed

SQL>