Re: [Fwd: How to change the SQL PLUS Window's Title]

Hi Palani,
I am not sure if this possible because the Login Database Name is a Runtime variable unless you always connect to the Same Db.

For eg , after Logging on to DB_1 using sqlplus,
> connect User/pass_at_DB_2

will change the Login Database name to DB_2 and I dont think you can reflect this on the Title.

However you can try to set the SQL Prompt in the Sqlplus Startup Script glogin.sql
based on the Database name you are connecting to. But Still I am looking for a Perfect script which can dynamically change the Sql Prompt reflecting the USername/Database name you are connected to.

-Thiru

Palani wrote:

> ----------------------------------------------------------------
>
> Subject: How to change the SQL PLUS Window's Title
> Date: Sat, 19 Jun 1999 21:56:44 +0200
> From: Palani <palanichamy_at_mailcity.com>
> Organization: RIMO Bedag Gemeindeninformatik AG, Switzerland
> Newsgroups: comp.databases.oracle.tools
>
> Dear Readers,
> How to change the SQL PLUS window's title from
>
>
> [Image]
>
> Oracle SQL*Plus to Any name with the login database name.
>
> Thank u,
> Palani
>
Received on Mon Jun 21 1999 - 12:08:33 CDT