Toad World® Forums

Toad formatting for select


#1

Hi

I have a query say something like below

select

ababa, – Name

dfa,-- Address

dasfas – State

from dual;

Now I need a formatter setting so it appears like below where inline comments should be formatted as below (in same line)

SELECT

ababa, – Name

dfa, – Address
dasfas – State
FROM DUAL;

Can you please tell me the formatter setting ?

Thanks

Matt


#2

In Toad you need to select View -> Toad Options

and on the right pannel of the new window , you will find an option named Formatter,

Open this option and on the right side of the window you will find the options Comments.

you only need then to check the option Align at the right margin.

Note: if your sql has not more than 3 columns it won’t format the comment’s well,

example:

An sql with 3 columns will be formated something like that below

SELECT AAA, --Comment

                    BBB,                                         --Comment

                                            CCC                             --Comment

    FROM TABLE

The reason for that is that the List Defaults option list arrangement in Formatter is set to more than 3 columns , so if you have 4 columns the Formater will be like this

SELECT AAA, --Comment

    BBB,                                 --Comment

    CCC ,                                --Comment

    DDD                                --Comment

FROM TABLE
Capture.jpeg