Beautifier . disable for certain lines?

[Frank Kintrup]

Hello,

I would like to turn off the beautifier for certain blocks of code. Is there a special comment which would do the trick?
If not please consider this a humble request ;-)

Frank

 

[Stew Stryker]

Frank,

I assume you don't like selecting the lines to be beautified?

That works pretty well for me, though I've been known to copy lines of a SELECT that I think the Beautifier messes up, beautifying everything and then pasting the SELECT back over the beautified/messed up version.

If they considered this as a possible enhancement I'd like to see it implemented in 2 forms, just like comments:

-- <nobeautifier>

would stop the Beautifier from changing all lines following this comment until it hit a blank line. This would be great for telling it to ignore an especially-complex query.

/* <nobeautifier=on> */
multiple
lines
of

code
/* <nobeautifier=off> */

which would be good for large chunks of code

Okay, maybe I've got way too much time on my hands to be thinking about stuff like this!

Frankly I'd rather see the Beautifier enhanced to:

* Support some of the newer syntax, such as the WITH clause in a query and,

* Allow me to specify how I want CASE statements formatted in the Control Structures section.

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[Marco van der Linden]

hmm, and matching braces in same column....

 

[Stew Stryker]

Marco,

Man that's gotta be a long list!

Very off-topic from PL/SQL Developer but speaking of enhancement lists, does anyone here use the Jira issue management software package (www.atlassian.com) for managing projects, bugs and issues lists? I've been evaluating it for our use for the past couple weeks and I'm very impressed.

If anyone's used it could you please drop me an email letting me know how you liked it? I'm trying to talk it up with the decision-makers around here but some first-hand, real-world experience would go far.

Thanks,

 

[amihay gonen]

hi i think the request to disable certain code will be usefully enchantment.

We are using the beautifier as standard in our shop.
The problems is the sometime complex code are need to be kept as they there are.

I think of running the beautifier as automatic fashion on our code in VSS.

 

[til]

And a blank after the leeding komma would be very nice (in column and parameter lists)

 

[mwakula]

FYI (as there is no documentation, feature has closed source and is not intuitive): This seems to work

-- NoFormat Start
CASE WHEN x=0 THEN NULL ELSE 100 * y / x END
-- NoFormat End

 

[jlcox]

FYI (as there is no documentation, feature has closed source and is not intuitive): This seems to work

-- NoFormat Start
CASE WHEN x=0 THEN NULL ELSE 100 * y / x END
-- NoFormat End

It is documented, it's in the PL/SQL Developer Help Manual, section 25.4, titled "Suppressing formatting"