Toad World® Forums

Adding a Blank column with a header in a Toad query

Question: How does one add a blank column containing a header within a query in TOAD? I want to create a query that I can export to Excel and have others input a few items after running my report. Any suggestions, I am very thankful for any input.

How about adding an extra column to your query?

So, instead of

Select a, b, c

from my_table;

do this:

select NULL as blank_column, a, b, c

from my_table;

That worked like a champ. Thank you.