RE: Formatter in TOAD for Oracle 11.6

"MCALLISTER, MICHAEL CTR AETC AETC/A3IS" <[email protected]>
Newsgroups gmane.comp.db.oracle.toad.free
Message-ID <4DA48F51EE503444872CA8706603DE501EFD6EC3D3@52VEJX-MV14-01.area52.afnoapps.usaf.mil>
I had this issue and logged a support case on it. It is a known issue with the 
formatting module, however the version of the formatting module that is in the 
beta already addresses this issue. So - next release should solve the problem.

Regards,

Mike McAllister
Principal Systems Engineer
Decypher
DSN:                      487-3751
Commercial:       (210) 652-3751
Cell:                       (512) 423-7447
Email:                    [email protected]

-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of t_rott
Sent: Tuesday, November 20, 2012 3: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
smime.p7s (application/pkcs7-signature, 5.5 KB) - not displayed
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.