Toad World® Forums

Toad Formatter

Hi,

I have a doubt regarding code indentation. It seems we can change the style of indentation according to us. I want clear view on it.

SELECT empname FROM employee WHERE empid=1

If I am using formatter it will indent as follows

SELECT empname

FROM employee

WHERE empid=1

But I want it to be happen as follows

SELECT

empname

FROM

employee

WHERE

empid=1

I came to know this can be done by formatter, but I don’t have idea about it.

So I am requesting you people to help for the above

Thanks,

MG Sai Chander
Email Id : mgsaichander17@gmail.com

Near the formatter options please select:

Alignments -> DML Statements -> Keywords LEFT aligned on own line

Hope this helps,

Andre

Hey [mention:5642d9e80729433eaed1dc5a8f2f2a12:e9ed411860ed4f2ba0265705b8793d05] , Thanks alot for answer. It helped me alot but i want help in certain areas like,

I want parameters to be in the next line with a tab space after JOIN statement also

SELECT

Empname,Empid,EmpSal

FROM

Emp_personalInfo per

JOIN

Emp_officalinfo off

ON

per.Empid = off.Empid


I want parameters to be on next line after parenthesis like

AND

(

Empid = 1

OR

(

Empid = 2

AND Empname = “Sai”

)

)


Is it possible. If so how?

Eagerly waiting for your reply… :slight_smile: :slight_smile:

We did not design to wrap JOIN and ON clauses/subclauses on their own line the way you are showing, because they are subordinate to the FROM clause. Of course it could be done for this simple join, but then what if the join becomes more complex?

About the AND/OR, by selecting Stacked style in the AND-OR pane you can already get the following format:

     AND (Empid = 1
OR (Empid = 2
AND Empname = "Sai"))

So I’d understand that you would require an option to lay out the parentheses differently, a little bit as was done near the List Arrangements, correct? This would then result in what you are suggesting.

Yes, [mention:5642d9e80729433eaed1dc5a8f2f2a12:e9ed411860ed4f2ba0265705b8793d05] You clearly understood what was i suppose to know.

May I know is it possible. If not may i expect this features in next version.