The PL / SQL Beautifier behaves differently with and without the hint.

[Jun9]

Dear administrator.

Even if it has with hint in with statement
I want the "without hint in with satement" style.

-- without hint in with statement
WITH without_hint_stmt AS
(SELECT 'a' char1
,'a' char2
,'a' char3
,'a' char4
FROM dual)
SELECT * FROM without_hint_stmt;

-- with hint in with statement
WITH with_hint_stmt AS
(SELECT /*+ materialize */
'a' char1
,'a' char2
,'a' char3
,'a' char4
FROM dual)
SELECT * FROM with_hint_stmt;

Thank you in advance.

 

[YellowShark]

Thanks for bringing this up!
This is a long time nuisance (easy to be solved by TABbing the select-columns).

 

[Marco Kalter]

We'll check it out.