Feature req. Batch beautify

[Paul Ljungqvist]

Is there a way to batch beautify an entire schema?

Quite regular I have to compare our customers schema objects to our 'Master DB'.
If there is a different indentation or style of the code, I will have a diff, using 'Compare user objects'.
The solution is to manually add beautyfier on all customer objects that will be compared.
This is time consuming.
So I would like to apply the beautyfier on a bunch of selected objects, or an entire schema.
Could this be done?

 

[Marco Kalter]

You can run the PL/SQL Beautifier from the Command Window. See this topic for an example.

 

[Paul Ljungqvist]

I guess that means no.
Would it be possible to add this feature?

 

[Marco Kalter]

I'm not sure what you mean. Why does this mean "no"?

 

[Hilarion]

I'm also not sure, but I think it looks like this:
- Paul wants to beautify the DB object sources (not source files) and the thread you pointed him to is about files (but AFAIK same method should work for objects).
- By pointing him to the thread you implicitly stated that the Developer does not have the ability to beautify entire schema (one has to make command window script that launches beautifier for each schema object).

So to Paul:
For now one has to write a command window script that launches "beautify" command for each schema object.

and to Marco:
Consider adding Paul's suggestion (functionality to beautify entire schema without having to write scripts) to feature request list.

 

[Paul Ljungqvist]

With the method explained in the thread mentioned above, I have to extract all user objects to files, and then apply the beautifer as suggested, and finally apply the changes by create or relace the objects again. Correct me if I have missunderstood it.
I wish to apply beautifier on multiple objects in a schema, in a simple way.
E.g select all packages, and package bodies in the browser, and then apply beautifing on the objects. Or apply it to the entire schema, without open every object.
If you wish to compare a schema with a "Master" and there are hundreds of objecs - triggers, views, procedures..., this will be very time consuming.

EDIT: Hilarion, that is exactly what I ment.