Jay,
We're talking about the SQL*Plus Worksheet for Windows here, not good old plain
SQL*Plus. Your solution only works for SQL*Plus, but not the Worksheet.
Cheers,
Leng.
-------------
From: [EMAIL PROTECTED]
Date: Mon, 3 Feb 2003 14:38:35 +0530
Subject: RE: SQL*Plus Worksheet Question
This is a multipart message in MIME format.
--=_alternative 0032130465256CC2_=
Content-Type: text/plain; charset="us-ascii"
Hi leng,
The following works fine with SQL*Plus if you include it in
Glogin(Login).sql
column user new_value A noprint
column global_name new_value B noprint
select user from dual;
select global_name from global_name;
set sqlprompt &A@&B.....
HTH ...
Regards
JAI
"Kaing, Leng" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/03/03 11:59 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: SQL*Plus Worksheet Question
> Eric,
>
> Not sure what you're talking about but here's a stab in the dark...
>
> set sqlprompt "mydb.myusername> "
>
> This changes the output prompt, but not the prompt in the header of the
window bar. If you can figure this one out, please let me know too.
>
> Rgs,
>
> Leng.
>
----------------------------------------------------------
Leng Kaing
Email: [EMAIL PROTECTED]
Phone: +61-417-371-348
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Kaing, Leng
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
