Query result is not export to Excel when running automation script

Toad for Oracle
1

The query is as the following:

SELECT TABLE_NAME,COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME = ‘Customer’
order by COLUMN_NAME

The expect result should be as the following in result excel file

TABLE_NAME COLUMN_NAME
Customer CustomerAccountID
Customer CustomerAdhocEmail
Customer CustomerBusinessEmail
Customer CustomerBusinessNumber

The actual result is as the following:

TABLE_NAME COLUMN_NAME

Steps to re-create:

  1. Select the query
  2. Select export excel file
  3. Uncheck “overwrite” check box
  4. Open “Advanced Properties” window and then check "Use column name for a header row
  5. Run the automation scripts

Query result is not export to Excel when running automation script

2

Is this Toad for Oracle that you are talking about? The options and features that you mention are similar to what we have in Toad for Oracle, but a little bit different…which makes me think you have Toad for SQL Server or something else.

If you are using Toad for Oracle, please post a screen shot or two so I can be more clear about what you are doing. If you are using Toad for , well, you’re in the wrong forum, so I can’t help you.

3

good info