RE: Formatter in TOAD for Oracle 11.6

Do you have the option View|Options|Files|General|"Save source files in Unix format" checked? If so try unchecking that and see if the problem is resolved. I seem to remember this coming up recently and I can no longer reproduce in the current source or in the upcoming patch build.

Michael

-----Original Message-----
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



------------------------------------

Yahoo! Groups Links





------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/