How to filter a column in Oracle Sql Developer

Question

Say I have several timestamp fields in a column that look like "02-JUL-14 10.36.07.713000000 PM".

Is there any way for me to left-click on a column in this table and do a search containing "JUL" so that I only have rows containing "JUL"?

I read articles by people saying that they include the% and 'characters around the word, and using the LIKE syntax', but nothing worked for me.

So, in the image below, I would like to just enter “JUL”, and only rows with a TIME_OF_ENTRY column containing the letters “JUL” will appear.

I understand that the input in the filter window below is an EXACT search, but I want to know if there is a “contains” type search method.

Answer 1

Embed

like '%JUL%' 

in the filter field, and any values ​​in this column containing "JUL" will be displayed.

http://www.thatjeffsmith.com/archive/2011/11/sql-developer-quick-tip-filtering-your-data-grids/ the link from @OldProgrammer contained the solution I found. Perhaps there may be more useful things in this link for more advanced filtering.

Answer 2

Type of

 to_char(TIME_OF_ENTRY) like '%JUL%' 

in the filter field above.

Answer 3

The to_char(fieldname) like `%likevalue%` worked for me using NetBean 8.0.2. I put it in the main filter field at the top of the page with the corresponding field name and likevalue and made sure that the fields of the individual filters were cleared. I removed the percentage signs when I do not need them.