title: How to filter a column in Oracle Sql Developer
body: <p>Let's say I have some timestamp fields in a column that look like this "02-JUL-14 10.36.07.713000000 PM".</p>
  
  <p>Is there a way for me to left-click the column in that table and do a search that contains "JUL" so that I only have rows show up that contain "JUL"?</p>
  
  <p>I have read articles of people saying to include % and ' characters around the word, and using the LIKE ' ' syntax, but nothing has worked out for me.</p>
  
  <p>So in the picture below, I wish I could just type in "JUL", and only rows with the TIME_OF_ENTRY column that contain the letters "JUL" will appear.</p>
  
  <p>I do realize that typing in the filter window below is an EXACT search, but I want to know if there is a way to do a "contains" type of search.</p>
  
  <p><img src="https://i.stack.imgur.com/hDE5i.png" alt="enter image description here"></p>