下划线在oracle like子句中不起作用 [英] Underscore is not working in oracle like clause

问题描述

开发时，我使用'test_1％'来查找'test_123'.但是在生产环境中它不起作用.使用'转义'\'是可行的.在oracle中需要设置什么设置吗?我想不加转义地使用'\''.

When development, I used 'test_1%' to find 'test_123' in like. But in production environment its not working. Using 'escape '\'' is working. is there any setting needs to set in oracle? I want to use without escape '\''.

推荐答案

在SQL Developer中尝试以下操作:

try this in SQL Developer:

SELECT * FROM TABLE1 WHERE NAME LIKE 'test\_1%' escape '\'

在sql plus中:

in sql plus:

set escape '\'
SELECT * FROM TABLE1 WHERE NAME LIKE 'test\_1%';

这篇关于下划线在oracle like子句中不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！