SQL Prompt 5 and INSERT statements

webrunner

Hello experts,

When I format SQL for an INSERT statement, the columns in the INSERT clause are always formatted with a line break after each column. But I want them to match whichever format I choose (new line break or not) depending on what the SELECT statement has. I am using a SELECT statement rather than a VALUES clause to provide the insert values, like this:

INSERT INTO MyTable ( col1,
                      col2,
                      col3 )
SELECT col1, col2, col3

Is there any way to have these two formats match, such as:

INSERT INTO MyTable ( col1, col2, col3 )
SELECT col1, col2, col3

or

INSERT INTO MyTable ( col1,
                      col2,
                      col3 )
SELECT col1, 
       col2, 
       col3

Let me know if you need more information.

Thanks for any help!

webrunner