Simple query (OpenEditor inside SQLTools 1.4.1 Beta
FROM TBL@A A_ED
WHERE A_ED.SETID = E.SETID
AND A_ED.CHARTFIELD1 = E.CHARTFIELD1
OR A_ED.EFFDT <= SYSDATE)
Place cursor just after first '('. After 'Find Match'
cursor goes before 'FROM' keyword, second time
before 'WHERE' keyword, finally goes before last ')'.
This behaviour is identical if you place cursor in the
middle of 'SELECT', 'FROM' and 'WHERE'.
In another keywords like 'AND', 'OR' or in variables
cursor don't change its place (it doesn't find a
Proper behaviour (in my opinion): if cursor is before
or after '(' apropriate match is found. In another
places cursor doesn't move or proper message is shown.