TOAD For Oracle 13.1 Code formatting

Toad for Oracle
1

Hello,

How do I configure the formater in Toad so that joins do not keep getting indented till kingdom come?

I want to prevent a situation where it just keeps going to the right from the screen after each left join. As in it puts it in a new line but indents it so that it starts at the last position of the last one. I want them in a nice column block going down.

Indent
Indent.PNG1637×290 7.73 KB

2

Hello pkainga,

It looks as putting the join clauses inside pairs of parentheses doesn’t yield a nice format.
Are the parentheses really required, could you work around and remove them?
Due to left-to-right evaluation, both queries…

SELECT COUNT (*)
  FROM ((a LEFT OUTER JOIN b ON a1 = b1) LEFT OUTER JOIN c ON a1 = c1);

…and…

SELECT COUNT (*)
  FROM a LEFT OUTER JOIN b ON a1 = b1 LEFT OUTER JOIN c ON a1 = c1;

… should yield the same results, AND the latter formats better!

In the meantime I’ll look how to enhance joins inside parentheses.

Thanks,
Andre