Object Browser does not filter properly, etc. ...

[CTucker]

Issue #1) When I have "use DBA Views if available" set in my options and I filter my Object Browser the "Database Links" branch does not filter. I'm not sure if other branches behave in this manner as well, but I certainly noticed the problem here.

Issue #2) The new feature of having a drop down list for columns with check-constraints in the edit record of the SQL results window does not work correctly. When the check constraint is for a text string, e.g. column_1 in ('Y', 'N'), the strings are placed in the drop down list with the quotes so when you select a value from the list it actually violates the check constraint, e.g. 'Y' Y.

*** Wish List - It would be nice to see an additional column in the describe table window that lists the constraints that the column is part of, e.g. primary key, unique key, foreign key. Perhaps have the sequence for the column in the constraint placed after the constraint name in brackets, e.g. emp_pk(1), emp_uk(2), emp_dept_fk(1)...

If this slows things down to much perhaps add two options to the right-click menu, e.g. "Describe" and "Describe w/ key constraints".

Thanks,

BTW... Keep up the good work. I've just converted over some staunch SQL Navigator and TOAD users over to PLSQL Developer. They really like the way the tool is geared to development, allows user extensibility - and the fact that the turn around time for bug fixes plus additional features and functions is very quick.

 

[Marco Kalter]

Issue #1) When I have "use DBA Views if available" set in my options and I filter my Object Browser the "Database Links" branch does not filter.

This works fine when I try it. Are you sure you have select privileges on the dba_db_links view?

Issue #2) The new feature of having a drop down list for columns with check-constraints in the edit record of the SQL results window does not work correctly. When the check constraint is for a text string, e.g. column_1 in ('Y', 'N'), the strings are placed in the drop down list with the quotes so when you select a value from the list it actually violates the check constraint, e.g. 'Y' Y.

Yes, we noticed. This is fixed for 5.1.2.

*** Wish List - It would be nice to see an additional column in the describe table window that lists the constraints that the column is part of, e.g. primary key, unique key, foreign key. Perhaps have the sequence for the column in the constraint placed after the constraint name in brackets, e.g. emp_pk(1), emp_uk(2), emp_dept_fk(1)...

I have added this to the list of enhancement requests.

------------------
Marco Kalter
Allround Automations

 

[CTucker]

I do have select on DBA_DB_LINKs. What I meant by the Object Browser not filtering is that I always see all database links regardless of my browser filter, e.g. If I filter on My objects I still see all db links. Perhaps this is how it works, but it caught me by surprise.

Thanks,

 

[Marco Kalter]

I see what you mean. A database link is not a "normal" object. It is not included in the all_objects view. Therefore it is not affected by the filter, which is essentially a where & order by clause for the all_objects view.

The same goes for users, roles, profiles, and so on.

------------------
Marco Kalter
Allround Automations