Re: RE: Code Formatting issues...

 Message from: eric.rodriguez_390

Can you tell me when this might be fixed?

Thanks...

_______________________________________

Historical Messages 


Author: eric.rodriguez_390
Date: Tue Dec 20 11:36:45 PST 2011
Can you tell me when this might be fixed?

Thanks...
__

Author: eric.rodriguez_390
Date: Tue Dec 06 13:46:58 PST 2011
Thanks! That is the option I had selected but I did not like the compressed look. I am glad to see that the alignment will be fixed soon!

-Eric
__

Author: Andre Vergison
Date: Tue Dec 06 12:55:00 PST 2011




 

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


__

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...
__
_______________________________________