Fuzzy query in oracle with special symbols

Fuzzy query in oracle with special symbols the It can be queried with the like statement, but it cannot be recognized if there are special symbols, such as: #, %, _, etc. the You can use regexp_like (field name, ‘fuzzy words with special symbols’) this query the Example: www.2cto.com the SELECT * the FROM USER_SOURCE T the WHERE TO_CHAR(T.US_TIME, 'yyyymmdd') = '20120615' the AND REGEXP_LIKE(US_FROM, 'hello#') the the Author monkey~