RE: Code Formatting issues...

Eric,

As a starter, select Operators & Punctuations, then AND-OR, then in Stacking Arrangement select the 3rd radio.
The layout is about what you wish to see, however it is fairly “compressed”. You may prefer the layout of the 2nd radio, but in that case the top level ANDs are not aligned below the WHERE keyword.
I’ll try to get that alignment in place for a next build.

Thanks,
Andre

________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of eric.rodriguez_390
Sent: dinsdag 6 december 2011 18:16
To: [email protected]
Subject: [toad] Code Formatting issues... [3 Attachments]


[Attachment(s) from eric.rodriguez_390 included below]

Message from: eric.rodriguez_390


Environment: - Toad for Oracle Professional (11.0.0.116) - Windows 7 64 bit - Oracle 10g - QPE v5.185.11230.41888 I have an SQL block that I am trying to format in a specific way and I am unable to get what I want. I have attached two .sql files. The first file (toad_formatted.sql) shows what I am able to achieve using my current formatter options, the second file (desired_format.sql) shows the output that I want. I have also attached my formatter options. Is it possible for me to get the desired output? Which formatter setting(s) am I overlooking? Thanks...

_______________________________________

Historical Messages


Author: eric.rodriguez_390
Date: Tue Dec 06 09:16:04 PST 2011
Environment: - Toad for Oracle Professional (11.0.0.116) - Windows 7 64 bit - Oracle 10g - QPE v5.185.11230.41888 I have an SQL block that I am trying to format in a specific way and I am unable to get what I want. I have attached two .sql files. The first file (toad_formatted.sql) shows what I am able to achieve using my current formatter options, the second file (desired_format.sql) shows the output that I want. I have also attached my formatter options. Is it possible for me to get the desired output? Which formatter setting(s) am I overlooking? Thanks...
__
_______________________________________