Highlighting a Tree View Entry
You can highlight a tree view entry by adding an additional column to the query of a tree view node. This results in the entry being displayed in a bold font type.
The additional column must get the "TREE_HIGHLIGHT" alias. When the retrieved column value is NULL, the entry is displayed in the default way. When the value is not NULL, it is displayed highlighted. For example:
,DECODE(count(c.FK), 0, NULL, 1) "TREE_HIGHLIGHT"
FROM PARENT p, CHILD c
WHERE p.PK = c.FK
GROUP BY p.prompt
In this example, the prompts of parent records that have child records are highlighted.