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