How to format for aligning select

Toad for Oracle & DevOps Toolkit
1

Hi,
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!

2

Hey, welcome to the Toad for Oracle forum...

I think you can get pretty close by looking at some of the AND/OR formatting options... see snap below, where changing the style to Stacked took your example to a nice alignment...

image
image1306×654 58.3 KB

3

Thank you,
the problem is that if I flag what you advised and I write;

select *
  from tab1,
       tab2,
       tab3
  where col1 = 3
  and   col2 = 5
  and   col3 = 6;

then if I push on "Format" botton below on the right I get:

select *
  from tab1, tab2, tab3
 where     col1 = 3
       and col2 = 5
       and col3 = 6;

image
image1214×531 31.2 KB

Where can/must I set the format for having this?

from tab1,
     tab2,
     tab3
4

Hi Marco,
This is about the closest I can get:
image

image

image

Does this help?
Thanks,
Andre

5

Hi,
thank you very much for the answer.
What I'd also like to have is the opportunity to have the right aligning automatically without having to select all the query and push to "Formatting Tools --> Format". For example with PLSQL Developer (Allround Automation) I get immediatly the desidered/personalyzed format as soon as I give on my keyboards after every row of the query.
Mark