how to set the name of sql results ?

[fredv]

Hello,

when I'm using a SQL Window with several queries and I execute it, I get several SQL Results tabs which I can export to Excel.

How can I set the name of each tab (of each query) to have the good name in the tabs of the Excel file ?

Thanks

 

[cct]

From the manual - Ad-hoc SQL:

By default the tab titles will be derived from the statements. To override this you can use a comment with a tab= expression before the statement. For example:

-- tab=Department 10
select * from emp
where deptno = 10;

In this case the tab title is Department 10 instead of the default Select emp

There are also a few more that can be used, that are list in the Help section 7.10 Comment directives.

I use them a lot.

--
Chris

 

[fredv]

Excellent ! thanks for your quick answer

 

[mobailey]

Thanks Chris - I didn't know this, and that tip will be truly useful.

-mobailey