Formal all Packages

[Charles Boeing]

Hello all,

There is a way to format all packages with beautifier ?

Thanks

 

[Marco Kalter]

Not directly, but You can use the BEAUTIFY command in the Command Window for batch operations:

BEAUT[IFY] File | Object
Beautifies the specified file or database object, using the current rules or the rules specified with the SET BEAUTIFIERRULES command.

 

[Charles Boeing]

Thanks Marco, this helpme a lot.

 

[vllr]

Marco,
not sure if I'm doing something wrong or just do not understand something.
What does BEAUTIFY Object exactly doing? I was expecting specified object being beautified in DB, but instead this is what is happening for me:
1. If Object is not currently opened in program window - running this command doesn't do anything.
2. If Object is currently opened in program window - this window is beautified.
Is it expected behavior? I was hoping just to build script for batch beautifying of hundreds of packages, but it doesn't look like working for me if this is expected behavior...
Could you please clarify?
Thank you!!!!

 

[Marco Kalter]

In version 14 option 1 did not always work correctly. In version 15 it beautifies the source from the database, and then recompiles the beautified source into the database again.

Perhaps you are using version 14 or earlier?