In View | Formatting Options | Operators & Punctuation | Commas, the My Example Code Window displays the following syntax warning:
1 FORMATTER messages:
** WARNING line 14, col 4, ending_line 21, ending_col 37,
Found: 'SELECT aaaaaaaaaaaaaaaa, bbbbbbbbbbbbbbbbbbb, cccccccccccccccccc, dddddddddddddddd, eeeeeeeeeeeeeee, fffffffffffffffff FROM mytab, histab, hertab WHERE histab.col1=hertab.col2'
Number of items in INTO and VALUES clauses does not match.
A similar message also displays for View | Formatting Options | Operators & Punctuation | Parenthesis
Syntax errors in commas.sql and parens.sql
WORKAROUND:
Replace 'commas.sql' and 'parens.sql' located in:
'C:\Documents and Settings\<username>\Application Data\Quest Software\Toad for Oracle\9.7\User Files\FormatterExamples' folder
with the attached files.
STATUS:
Waiting for fix in a future release of Toad for Oracle
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center