Sometimes the Toad Insight (Intellisense) feature gets in my way.
Take for example this scenario:
Let’s say I want to wrap something from the statement above in a function. For example say I want the first 60 characters of the CustomerName field.
The SQL Above is ALREADY in the editor, so you click in the character position immediately in front of “CustomerName”
When you type the function name and open the bracket: “LEFT(” you immediately get an intellisense list of fields – and that’s GREAT when there’s nothing in the cursor position immediately to the right of the open bracket.
But when there IS something there it’s because I’m adding this after the fact and I DO NOT want the intellisense to display.
So to wrap something in a function like left, I have to do this:
Click to the left of CustomerName
Press ESC key to close the intellisense window without making a selection
CTRL+Right Arrow to jump to the end of the field name.
Type the closing bracket: )
Press ESC key AGAIN because for some strange reason Toad Insight/intellisense is displayed AGAIN – even though I’m “Closing” the function and couldn’t possibly want that right now.
Point is having to hit the ESC key two extra times could be avoided if:
a) Toad insight were not displayed if character immediately to the right of the cursor position is not blank.
b) Toad insight were not displayed on keying closing brackets: )