Trying to see fewwer objects in dropdown lists.

aviator

Member
Hello, First time user, I am going to give a demo on the PLSQL Developer product to our development staff. I want to remove certain object from the drop down lists for tables. Currently I see EWL% tables and WB% tables. These are End user layer tables and warehouse builder tables. I only want to see my application tables . Is there a way to mask the selection to exclude certain table names not like 'EUL%' and not like 'WB%' Let me know. I will have many more questions over the next few weeks .
THANKS in advance.

------------------
 
You can add your own browser filters.
Go to: Tools - Browser Filters...
Add a new filter
In the where clause add something like the following:
Code:
owner = USER
AND (
     (    object_type = 'TABLE'
      AND object_name NOT LIKE 'EUL%'
      AND object_name NOT LIKE 'WB%'
     )
     OR object_type <> 'TABLE'
    )

------------------
Check out: http://www.oracledeveloper.nl
 
Back
Top