User Tools

Site Tools


technical_notes:public:sql-like-escape

Parent

SQL - Escape LIKE operator

SELECT a.TABLE_NAME, a.column_name
  FROM user_tab_cols a
  WHERE COLUMN_NAME LIKE '%ID!_%' escape '!'
technical_notes/public/sql-like-escape.txt · Last modified: 2015/01/20 12:35 by Fabien Arcellier