RE: Formatter in TOAD for Oracle 11.6

I've noticed the same. If I kept formatting, more lines are added. I eventually did something and it formatted normally.

Chris

From: [email protected] [mailto:[email protected]] On Behalf Of t_rott
Sent: Tuesday, November 20, 2012 4:50 AM
To: [email protected]
Subject: [toad] Formatter in TOAD for Oracle 11.6



Hi,
since the version 11.6 is the function "format code" adding blank lines to the SQL.
Code:
SELECT B.SBA,

B.SSAP,

AR.SBEZ,

B.SARTIKEL,

A.SCHRGE

FROM BBAUF A,BARBG B left outer join ARBP AR on B.SSAP = AR.SARBPL

WHERE B.SSAP = '4800LI08'

AND B.LISTBEGINNTAG = 150804

AND B.SBA = A.SBA

If I use the old style:
SELECT B.SBA,
B.SSAP,
AR.SBEZ,
B.SARTIKEL,
A.SCHRGE
FROM BBAUF A, BARBG B, ARBP AR
WHERE B.SSAP = '4800LI08'
AND B.LISTBEGINNTAG = 150804
AND B.SSAP = AR.SARBPL(+)
AND B.SBA = A.SBA

everythings works perfect. It occurs just on use of LEFT OUTER JOIN and an "," in WHERE clausel.
It worked without problems in version 11.5.
Is there something new in the Formatter options?
Thanks for your help

Tomas


______________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________

______________________________________________________________________
Attention:
This e-mail and any files transmitted with it from Hatch Mott MacDonald are confidential and intended solely for use of the individual or entity to whom they are addressed. If you have received this e-mail in error please immediately notify the sender.
______________________________________________________________________