Hi all,

Is there a reason for Beautifier not working in views? It is pretty frustrating... Does anyone have a workaround on this?

Thanks!

I agree with you, personally, I beautify the underlying query manually by selecting it and Ctrl-B.
But I would appreciate to beautify a file with views without this trick.

It should work. What exactly goes wrong?

Our views are in a file, which is opened in an SQL window (or a command window), and thus Beautifier has no effect.
We can't edit views in a program window.

[quote=Philippe Malera]I agree with you, personally, I beautify the underlying query manually by selecting it and Ctrl-B.
But I would appreciate to beautify a file with views without this trick.[/quote]

@Philippe, this is also my "work around"
@Marco, this view cannot be formatted:

CREATE OR REPLACE VIEW test123
AS
SELECT 1 AS c1,
b AS c2
FROM dual

Check view

Arky,

it work on version 13 and 14. I do remember it was an issue before.
Are you using an older version? You did not specify which version you use.

[quote=Arky]@Marco, this view cannot be formatted:

CREATE OR REPLACE VIEW test123
AS
SELECT 1 AS c1,
b AS c2
FROM dual [/quote]
This works fine for me. Can you let me know your PL/SQL Developer version?

Marco, I'm using the latest 14 32-bit version.
I downloaded also 64-bit just in case but the problem is the same

Are you using the SQL Window or some other window type? Are there more statements in the script than just the create view statement?

No, this is written in a new, plain SQL Window, with no other statements

UPDATE:
OK, this is good. I talked to all 4 developers of our team: Two of us have the same problem while the others don't.

Verdict: Format is NOT working if you select all code - Ctrl+A and press button. It works flawlessly if you DO NOT select any code but simply press the button.

Thanks a lot, problem solved!!