# Editor not highlighting column names correctly when specified table\_name.col\_name **URL:** \ **Category:** Toad for Oracle - Beta\ **Created:** [March 5, 2015, 5:25am UTC](https://forums.toadworld.com/t/editor-not-highlighting-column-names-correctly-when-specified-table-name-col-name/32781 "2015-03-05T05:25:50Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Boneist](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/boneist/32/145_2.png) [@Boneist](https://forums.toadworld.com/u/Boneist)\ **Post date:** [March 5, 2015, 5:25am UTC](https://forums.toadworld.com/t/editor-not-highlighting-column-names-correctly-when-specified-table-name-col-name/32781/1 "2015-03-05T05:25:50Z")
Hi, I have my highlighting set to display known user tables in an olive colour. However, I’ve noticed that when I refer to a table column as “existing\_table.column\_name”, in 12.6, the “existing\_table” is displayed in olive, and the “.column\_name” is displayed in black. In 12.7.0.49, they’re both displayed as olive: ![toad_incorrect_highlighting.jpeg](https://global.discourse-cdn.com/quest/original/2X/d/d82476c81dfc78f59a0d16864aec787d8a09fbe2.jpeg) I think the 12.6 behaviour is the desired one - please can it be corrected in 12.7? Thanks. ---
**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\ **Post date:** [March 5, 2015, 6:32am UTC](https://forums.toadworld.com/t/editor-not-highlighting-column-names-correctly-when-specified-table-name-col-name/32781/2 "2015-03-05T06:32:09Z")
For now there's no way to change the new behavior. I'll look at it when I have time, but the new and the old editor components handle things very differently so there are going to be some differences. If the list of table names is sent as-is then "test1" would highlight OK when standalone, but as soon as you tack a column name to it then "test1.col" will not highlight. The object names are sent so that they highlight when standalone or when typed as object\_name.anything. There are many cases of highlighting that could be more accurate if you start looking for them, but in some cases the extra work required to do so isn't worth it. In your test1.not\_a\_col example Toad would have to query for column names of your table to intelligently exclude that string from the list. That could be very costly. Michael On 03/05/2015 08:26 AM, Boneist wrote: > **[Editor not highlighting column names correctly when specified table\_name.col\_name](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/24021.aspx)** > Thread created by Boneist > Hi, > I have my highlighting set to display known user tables in an olive colour. However, I've noticed that when I refer to a table column as "existing\_table.column\_name", in 12.6, the "existing\_table" is displayed in olive, and the ".column\_name" is displayed > in black. In 12.7.0.49, they're both displayed as olive: > > I think the 12.6 behaviour is the desired one - please can it be corrected in 12.7? Thanks. > To reply, please reply-all to this email. > > [Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/24021.aspx?subscribe=false) on this subject. > > Or [ > Unsubscribe from Toad for Oracle - Beta](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86.aspx?subscribe=false) notifications altogether. > > Toad for Oracle - Beta Discussion Forum > [Flag](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/24021.aspx?AbuseContentId=01787683-7052-4c6f-9732-0f3f29331127&AbuseContentTypeId=46448885-d0e6-4133-bbfb-f0cd7b0fd6f7&AbuseFlag=true) > this post as spam/abuse. > ![](https://global.discourse-cdn.com/quest/original/3X/5/0/50b30fd5f87c85fe5cba2635cb83316ca71250d7.gif) ---
**Author:** ![Boneist](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/boneist/32/145_2.png) [@Boneist](https://forums.toadworld.com/u/Boneist)\ **Post date:** [March 5, 2015, 7:06am UTC](https://forums.toadworld.com/t/editor-not-highlighting-column-names-correctly-when-specified-table-name-col-name/32781/3 "2015-03-05T07:06:42Z")
The behaviour in 12.6 is the same regardless of whether the column exists in the table or not. Is it really too difficult to stop the highlighting once the full stop is encountered? That’s what 12.6 seems to do, anyway (tested for both tables and packages). ---
**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\ **Post date:** [March 5, 2015, 7:17am UTC](https://forums.toadworld.com/t/editor-not-highlighting-column-names-correctly-when-specified-table-name-col-name/32781/4 "2015-03-05T07:17:07Z")
> Is it really too difficult to stop the highlighting once the full stop is encountered? Yes. On the surface it seems easy, but what happens under the hood is at the core of the lexer which affects all syntax highlighting. Modifying the core lexer code to satisfy this one case will cause problems for many others. I'll look at it later in the cycle. On 03/05/2015 10:07 AM, Boneist wrote: > **[RE: Editor not highlighting column names correctly when specified table\_name.col\_name](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/24021/52535.aspx#52535)** > Reply by Boneist > The behaviour in 12.6 is the same regardless of whether the column exists in the table or not. Is it really too difficult to stop the highlighting once the full stop is encountered? That's what 12.6 seems to do, anyway (tested for both tables and packages). > To reply, please reply-all to this email. > > [Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/24021.aspx?subscribe=false) on this subject. > > Or [ > Unsubscribe from Toad for Oracle - Beta](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86.aspx?subscribe=false) notifications altogether. > > Toad for Oracle - Beta Discussion Forum > [Flag](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/24021/52535.aspx?AbuseContentId=130cdcfe-68f2-459b-9b69-f88bbd4efb88&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) > this post as spam/abuse. > ![](https://global.discourse-cdn.com/quest/original/3X/5/0/50b30fd5f87c85fe5cba2635cb83316ca71250d7.gif) ---
**Author:** ![Boneist](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/boneist/32/145_2.png) [@Boneist](https://forums.toadworld.com/u/Boneist)\ **Post date:** [March 5, 2015, 7:31am UTC](https://forums.toadworld.com/t/editor-not-highlighting-column-names-correctly-when-specified-table-name-col-name/32781/5 "2015-03-05T07:31:45Z")
Okie dokie; I know it’s a minor issue, but it looks really, really odd given that we’ve had the old behaviour for so long! Thanks for adding it to the list for when you’ve got time, though. ---
**Author:** ![m.tr](https://avatars.discourse-cdn.com/v4/letter/m/65b543/32.png) [@m.tr](https://forums.toadworld.com/u/m.tr)\ **Post date:** [March 21, 2021, 3:30pm UTC](https://forums.toadworld.com/t/editor-not-highlighting-column-names-correctly-when-specified-table-name-col-name/32781/6 "2021-03-21T15:30:43Z")
Hello How can I activate the highlighting set to display known user tables in an olive colour? Thx. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [March 21, 2021, 8:16pm UTC](https://forums.toadworld.com/t/editor-not-highlighting-column-names-correctly-when-specified-table-name-col-name/32781/7 "2021-03-21T20:16:24Z")
This to enable highlighting ![image](https://global.discourse-cdn.com/quest/original/2X/9/982cc5e55e601eda4827ef529649b236f3aed822.png) this to set the color ![image](https://global.discourse-cdn.com/quest/original/2X/4/4ddaaeec383a38d92df55ec6adba5d3b92362202.png) ---
**Author:** ![m.tr](https://avatars.discourse-cdn.com/v4/letter/m/65b543/32.png) [@m.tr](https://forums.toadworld.com/u/m.tr)\ **Post date:** [April 3, 2021, 11:22am UTC](https://forums.toadworld.com/t/editor-not-highlighting-column-names-correctly-when-specified-table-name-col-name/32781/8 "2021-04-03T11:22:24Z")
Hi John Thank you very much for your reply. That worked out, thx!