Highlight table names

Toad for Oracle & DevOps Toolkit
1

Hi,

I logged in with my username and set the option [Editor] > [Display] > [Highlight table name/ Highlight view names/ Highlight stored procedure names]. The Default Schema is another than the logon user name. Now the table names are not highlighted. Only the stored procedure names and the views are highlighted. Why are the tables names are not highlighted correct? Only the table names of the logon user are highlighted, not the default one. Have you any ideas why?

I like this feature. It makes the code more readable.

Kind regards

2

I can confirm that on Toad 12.5 beta.

The same behavior is if a table has a public synonym or not.

I see two problems to achieve that:

  1. grant select on all_table (dba_tables) … (do not forget dba_part_tables as well)

  2. performance to run that queries

So I think (mine own thought without any official confirmation from Dell!) this will never be implemented in a way you like.

Brg

Damir

3

Highlighting of tables and views should be consistent. I’ll take a look at it.

4

For views, it looks like we are highlighting every view known to man. Or at least to your database - once it is loaded into the schema browser. This kind of surprised me but it has probably been this way for a long time. I wonder at what point the size of this list causes performance problems.

5

The list is sorted and lookups are done via binary search so it should be speedy; however, since this is a syntax decoration feature lookups on the list occur a LOT so you'd think at some point it will have a negative impact.

On 11/05/2013 10:57 AM, John Dorlon wrote:

RE: Highlight table names

Reply by John Dorlon
For views, it looks like we are highlighting every view known to man. Or at least to your database - once it is loaded into the schema browser. This kind of surprised me but it has probably been this way for a long time. I wonder at what point the size
of this list causes performance problems.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

6

Views, Table, Stored Procedures are highlighted only on the logon schema, not on the default schema.

7

Patrick - what you said is true when a connection is first made. However, as other views and procedures are displayed in the Schema Browser, they are added to the list of words to be highlighted. This seems odd but it has been that way for a long time. I wanted tables to be consistent with views and procedures, so starting next beta, tables will behave the same way.