Hi,
I had a question regarding escaping special characters in Oracle. Lets say I have a table column which has data like '%_TEST%'. I deally if we do a select on this table, it would be something like
Select * from table where column like '%\_TEST%' escape '\'
However, when I run this query on sql developer
Select * from table where column like '%TEST%' , it returns the same result. (without escaping the special character _.
Wondering, if this is because sqldeveloper by default escapes the special character? or do we need to still write the escape as a good practice?
Thanks!
Ryan