Table T1 Col1 Col2 % 1 X 2 % 3
I need to return the rows which are all having %. Simply how to search the string % in Oracle.
SELECT * FROM T1 WHERE col1 LIKE '\%' ESCAPE '\';
SELECT * FROM Employee WHERE EmployeeName LIKE 's%'