In Toad Formatter, List Arrangements , Commas, I have elected Leading with single space. Toad is indenting and formatting a comma with multiple (2) spaces. Why? I believe "with space" implies a single (1) leading space.
Here is a simple script that shows the original unformatted code before reformatting and the result after formatting...
-- original before reformatting
SELECT segment1
, segment2
, segment3
, segment4
, segment5
, segment6
, segment7
, segment8
, segment9
, segment10
FROM gl.gl_code_combinations;
-- reformatted
SELECT segment1, segment2, segment3, segment4, segment5, segment6, segment7
, segment8, segment9, segment10
FROM gl.gl_code_combinations;
Please note that segment8 above has a comma and 2 leading spaces.
Workaround:
None
Status:
Waiting for fix in future release of Toad for Oracle.
