Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Variables in BTITLE or TTITLE
Capture &1 in a define like this
define person = '&1'
btitle 'Please return to &person'
It is a few years ago I needed this but it should work.
Hth,
Sybrand Bakker, Oracle DBA
Kurt R. Nowacki wrote in message <7fkmkb$12g$1_at_news.inc.net>...
>I'm trying to put a person's name into the BTITLE or TTITLE. The full name
>(two separate words) are sent into the SQL*Plus script as the first
>variable. When I put them into the TTITLE, it only prints out the first
>name.
>
>Ex.
>
>SQL*Plus program is called like this:
>
> program1.sql 'JOHN DOE'
>
>The formatting looks like this:
>
> BTITLE CENTER '** PLEASE RETURN TO &1 **'
>
>When the report prints out, the bottom title is this:
>
> ** PLEASE RETURN TO JOHN **
>
>How can I print out the full name of the person on the bottom title so that
>it reads:
>
> ** PLEASE RETURN TO JOHN DOE **
>
>Please reply to my email as well, as I don't get onto the ng as much as I'd
>like. Thanks!
>
>Kurt Nowacki
>knowacki_at_airadigm.NOSPAM.com
>Airadigm Communications
>
>
>
Received on Wed Apr 21 1999 - 12:12:06 CDT