How to filter a column in Oracle Sql Developer

sql oracle-sqldeveloper
joshpt picture joshpt · Jul 3, 2014 · Viewed 56.6k times · Source

Let's say I have some timestamp fields in a column that look like this "02-JUL-14 10.36.07.713000000 PM".

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"?

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.

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.

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.

enter image description here

Answer

joshpt picture joshpt · Jul 3, 2014

Paste 

like '%JUL%'

in the filter field, and whatever values in that column which contain "JUL" will show up.

The http://www.thatjeffsmith.com/archive/2011/11/sql-developer-quick-tip-filtering-your-data-grids/ link from @OldProgrammer contained the solution that I found. There may be more helpful things in that link for more advanced filtering, perhaps.

Related questions

Use tnsnames.ora in Oracle SQL Developer

I am evaluating Oracle SQL Developer. My tnsnames.ora is populated, and a tnsping to a connection defined in tnsnames.ora works fine. Still, SQL Developer does not display any connections. Oracle SQL Developer Soars mentions, that if you have …

Read More
How can I find which tables reference a given table in Oracle SQL Developer?

In Oracle SQL Developer, if I'm viewing the information on a table, I can view the constraints, which let me see the foreign keys (and thus which tables are referenced by this table), and I can view the dependencies to …

Read More
Oracle SQL escape character (for a '&')

While attempting to execute SQL insert statements using Oracle SQL Developer I keep generating an "Enter substitution value" prompt: insert into agregadores_agregadores ( idagregador, nombre, url ) values ( 2, 'Netvibes', 'http://www.netvibes.com/subscribe.php?type=rss\&url=' ); …

Read More