How to format for aligning select in Toad for Oracle

Question

I'm using Toad for Oracle 10.6 and when I write a SQL statement like this:

select *
from table1,
    table2,
    table3
where col1 = 3
and col2 = 5
and col3 = 6;

I use a TAB button after every AND and I'd like to get something like;

select *
from table1,
     table2,
     table3
where col1 = 3
and   col2 = 5
and   col3 = 6;

but in View/Formatting Options I can't find where to tune Could you help me? Thanks in advance!

Answer 1

Why would you ever manually format code? Use built-in formatter; adjust its setting so that they fit your needs.

For what you described, it looks like the following:

Formatter shortcut is <Ctrl + Shift + F>.