Βeautifier and views

[Arky]

Hi all,

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

Thanks!

 

[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.

 

[Marco Kalter]

It should work. What exactly goes wrong?

 

[Philippe Malera]

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.

 

[Arky]

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.

@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

 

[Nicolas D.]

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.

 

[Marco Kalter]

@Marco, this view cannot be formatted:

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

This works fine for me. Can you let me know your PL/SQL Developer version?

 

[Arky]

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

 

[Marco Kalter]

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

 

[Arky]

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!!

 

[Marco Kalter]

Indeed. We'll fix it.