Script Output tabs question

Toad for Oracle
1

I have scripts with multiple related queries. When I run them the Script Output section labels them as “Grid 1”, “Grid 2”, etc.

I thought I was able to “name” each tab by having a line like
TTITLE ‘query_of_stuff’
before my select statement and this would name the tab
query_of_stuff

I don’t seem able to do this any more. I’m using TFO 10.5.1.3 and I’m sure it worked when I was running TFO 9.something. Any ideas?

2

Looks like it’s a bug. It should be working but doesn’t seem to be. I’ll take a look.

Greg

3

NEEDS TO BE RUN FROM A DBA ACCOUNT

SET HEAD ON PAGESIZE 1000 LINESIZE 600
PROMPT
PROMPT

REM ======================================================================
REM
REM TITLE BLAH BLA BLAH
REM
DOCUMENT
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

BLAH BLA BLAH

$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

SELECT COL1, COL2, CL3 ETC
XXX
XXX
XXX
WHERE XXXXX ;

PROMPT
PROMPT
PROMPT
PROMPT

REM ======================================================================
REM
REM TITLE BLAH BLA BLAH
REM
DOCUMENT
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

BLAH BLA BLAH

$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

SELECT COL1, COL2, COL3 ETC
…
…
…
WHERE … ;

On Tue, Sep 7, 2010 at 1:28 PM, toad_dscyf wrote:

I have scripts with multiple related queries. When I run them the Script
Output section labels them as "Grid 1", "Grid 2", etc.

I thought I was able to "name" each tab by having a line like
TTITLE 'query_of_stuff'
before my select statement and this would name the tab
query_of_stuff

I don't seem able to do this any more. I'm using TFO 10.5.1.3 and
I'm sure it worked when I was running TFO 9.something. Any ideas?
4

This looks to be fixed for the upcoming 10.6 release.

Greg

5

Great, thanks.

Deborah M Flad, DBA
Office: 302.633.2694 Emergencies: 302.528.3652
“Please consider your environmental responsibility before printing this e-mail”
image001.gif