Beautifier

[Lee Bushnell]

I am brand new at this.
I would like to have my conditions on a separate line:

SELECT ...
WHERE a.col1 = b.col1
AND a.col2 = b.col2
AND....

I just can't find this option

thanks

 

[oghislain]

I sended you a mail with a screenshot

Regards

Olivier

 

[Niek]

With PL/SQL Developer 6 the AND/OR conditions can be put on another line, but not for combined ones...

I would like to line out the comma the way shown below too and also show the alias capitalized:

As is right now:

SELECT o.id
      ,o.description
FROM
ORDER  o, prices p
WHERE  p.price < 20
AND    o.price_id = p.id
AND    (o.TYPE = 10 OR o.TYPE = 20)

But would like to have:

SELECT O.id
,      O.description
FROM   order O
,      prices P
WHERE  P.price < 20
AND    O.price_id = P.id
AND    (  O.type = 10
       OR O.type = 20 )