I am using TOAD for Oracle, version 220.127.116.11. When I am using the Editor (Database > Editor), with the Object Palette displayed, I like to double-click column names to add them to a query I am creating. However, when I do this, the column names are added without commas. For example, I get this:
select currentstatus program last_modified_by…
instead of this:
select currentstatus, program, last_modified_by…
I find that I have to manually insert the commas, which is silly. There must be a better way.
Note: If I use the key to select more than 1 column, and then drag to the Editor window, commas are inserted, as expected. It is just when double-clicking column names one-at-a-time that I get the spaces without a comma.