Toad World® Forums

SQL Formatter - make RETURN statement to be on the same line as closing parenthesis in function declaration/definition

Hi,

the title says it but here's an example:

Desired outcome:

FUNCTION get_config_entry_id(
    p_namespace  configuration.namespace%TYPE,
    p_key        configuration.key%TYPE,
    p_scope      configuration.scope%TYPE
) RETURN configuration.id%TYPE;

Formatter output:

FUNCTION get_config_entry_id(
    p_namespace  configuration.namespace%TYPE,
    p_key        configuration.key%TYPE,
    p_scope      configuration.scope%TYPE
)
    RETURN configuration.id%TYPE;

Any1 knows how to do that? I was going through the formatter options but I cannot achieve this.