top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

How to search the '%' in a table?

0 votes
58 views
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.

posted Aug 18, 2014 by Ela

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

0 votes

SELECT *
FROM T1
WHERE col1 LIKE '\%' ESCAPE '\';

answer Sep 11, 2014 by Arun Gowda
0 votes
SELECT * FROM Employee WHERE EmployeeName LIKE 's%'
answer Nov 17, 2014 by Manikandan J
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...