Sqlplus and TTITLE

From: Joe Condle <condle_at_mars-systems.com>
Date: 2000/04/21
Message-ID: <39005795.56B86B1@mars-systems.com>#1/1

I want to run multiple querries in a script and change titles between querries.

I have tried

TTITLE Center 'Title 1'

spool A
query1
spool off

TTITLE Center 'Title 2'
spool B
query1
spool off

This does not work. The only thing I can do is turn off the second TTILE and then cat the title I want with the unix cat command.
Thanks in Advance

Joseph P. Condle Jr.      condle_at_mars-systems.com   Office 412-473-6542
Senior Systems Engineer                             Fax    412-473-6538
Medical ARchival Systems, Inc.  (MARS)              Pager  412-572-9490

1310 Beulah Road Pgh. Pa. 15235 USA Received on Fri Apr 21 2000 - 00:00:00 CDT