oracle-databaseoracle11goracle10g

Underscore is not working in oracle like clause

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 '\''.

Solution

  • try this in SQL Developer:

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

    in sql plus:

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