How to handle/use special characters like percent (%) and ampersand (&) in Oracle SQL queries

Viewed 17249

I need to include the special character "%" in my LIKE clause in a SQL query, e.g.:

Select * From Some_Table Where Field_Name Like 'bla%bla&2';

How do I write that?

5 Answers
Related