Beatifier vs Optimizer/Query-Hints

YellowShark

Member²
Hello,

When a query uses optimzer hints, the Beautifier cannot align the (selected-) columns properly, like it would do without the hints (applies to both PL/SQL Dev 12 and 13):

SQL:
--beautifier without optimizer hints
SELECT t.a
      ,t.b
      ,t.c
  FROM myTable t
 WHERE 1 = 1;

--beautifier witoptimizer hints
SELECT /*+optimizer hints...*/
 t.a
,t.b
,t.c
  FROM myTable t
 WHERE 1 = 1;

 
Last edited:
Back
Top