Beautifier Problem

[Ameen]

Hi
The Beautifier does not work if the code contains statement like:
"Create or Replace View".
Also the beautifier does not work if any program unit (function, procedure, package...) was opened in View mode (not Edit mode).

 

[Marco Kalter]

The PL/SQL Beautifier, as the name suggests, only works on PL/SQL, including the subset of SQL that can be used in PL/SQL. For a view you can therefore mark the select statement and beautify it.

Read-only sources can indeed not be beautified (or modified in general).