Toad World® Forums

Formmater options to not stack parameters in internal functions?

Is there an option on formmatter options to prevent the parameters of internal functions to go the the next line and get stacked?

I’m using SQL Navigator

This is what I get:


This is what I wanted:

SELECT NVL (SUBSTR (RTRIM (a3.VALUE), 1, 25), ‘n/a’)

Parameter lists with nested functions are not easy to format. The statement you are presenting can format in a flat way (which you desire) whenever the right hand margin is 53 or higher. That means that inside your code unit, if it folds the way you show, the statement must have been indented quite a bit assuming you use a normal right margin (say 80). Perhaps increasing your right hand margin would help. After all, the right margin is a hint which is useful whenever the code is displayed in fixed window of a given size with no horizontal scroll. In this case formatter tries to make all of the code viewable. In an IDE I’d rather set the margin high, and use the list arrangement options to stack wide lists.

I’m open to any suggestion which could help improve such formatting.


Thanks Andre, I increase a little the right margin and also changed the option columns in the parameters section and it seems to have solved the issue.

I think that there are too much configuration and also that they do not explain well what they do!