In any SQL statement, Views are not highlighted (or displayed with yellow/gold color), in contrast to the Tables and Procedures which are.
Also, if you are using an Oracle user which is not the owner of the object, the object name is not highlighted in the Editor.
The syntax highlighting for View is disabled by default in the options
RESOLUTION 1:
You can enable highlighting for Views in the following place:
1. Go to:
View | Toad Options | Editor | Display | Highlight Object Names
2. Enable the 'Views' tick box and press OK, and the views highlighting should be enabled in the Editor.
RESOLUTION 2:
If you are connected with a user that is not the owner of the object, the objects are not highlighted (even if the step in RESOLUTION 1 above is done). This is by design for performance reasons for the Editor.
Toad cannot keep track of all table names in the database for the purposes of highlighting, because there are too many, and performance in the Editor would suffer.
There are a couple of things you can do to help this though.
1) If you are working with packages, and the packages reference tables in other schemas, and you want to highlight those tables, go to Options -> Editor -> Display. On the right, in the "Highlight object names" box, check "dependencies from other schemas"
2) If you want to highlight tables/views from a specific schema besides the login schema, Go to the Schema Browser and select that schema in the dropdown, so the table names for that schema are displayed. You can do the same with Views. That will load them into the list of table/view names to be highlighted.
