Naming Multiple Tabs in SQL Window

[M.Musson]

Question and/or Enhancment Request:

I'm very fond of exporting results to Excel from SQL window. Especially helpful when there are multiple datasets that need to be exported -- I can now do this in one fell swoop by exporting them all at once!

However, the tab names still have something to be desired. I see they take the format of 'Select' +

. I can't seem to force anything else into them. Ideally, a facility would be provided so that when I run the code, it will name the SQL tab what I want instead of the default format.

Unless there already is a way (that's my question -- is there?), then I suggest that an enhancement be made so SQL window tabs can be user-named. Perhaps by taking whatever appears immediately after the table that is being selected from? For example:
select * from dual --mynamedtab
would display "mynamedtab" as the tabname instead of "select dual" as it does now.

Then, when the results are exported to Excel, Excel would in turn use the correct tab name as well.

Regards,

Matt

 

[Adam Hill]

I agree. Possibly some sort of general-se PL-SQL initial comment code which also names the sessions? Session names adapt to a comment at the beginning once the query is run, perhaps some specific syntax could carry that through to the results?

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[deaneaux]

Is there a way to name the output tabs yet? I've been searching on how to do this, and this is the only thread that I found.

 

[Marco Kalter]

This has been added in the upcoming 9.0 release.