Filters
989871Feb 7 2013 — edited Feb 9 2013I am converting over to Oracle SQL Developer from Allround Automations PL/SQL Developer and I have a question about setting up filters for objects.
If I want to setup a filter under Other Users, it seems like I can only do that by schema name and there doesn't seem to be any AND or OR ability to build the search criteria. In the IDE I was using before this I was able to setup a filter that looked like..........
owner LIKE '%GOLF%' OR object_name LIKE '%GOLF%'
So then when I clicked on Procedures it would bring back a list like................
COM_XML.GOLF_TEE_TIMES
COM_STE.GOLF_SCOREBOARD
CUSTOMER_DATA.GOLF_SCHEDULE
GOLF.PLAYER_STATS
LIVE.LIVE_GOLF_CUP_TEAMS
So, any object that has the string 'GOLF' anywhere in it, whether it's the schema name or part of the object_name is returned.
Is there a way to do this in Oracle SQL Developer? I'm using 3.2.20.09
Thank you!
Edited by: 986868 on Feb 7, 2013 12:49 PM