SQL*Plus name change

[former_member192421]

Hi Everyone,

I have a weird question,

Whenever you start SQL*Plus in command prompt, This message is shown always:

SQL*Plus: Release 10.2.0.5.0 - Production on <DAY><MONTH><DATE><TIME><YEAR>

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

Connected to an idle instance.

Can any one tell me how can I change the name "Production" to "QA" or "DEV" in the above?

Thanks in Advance.

Regards,

Rajkumar

[Former Member]

You can't.
This text is hardcoded in the sqlplus program, provided by Oracle.
It isn't open source, and so you can't make changes of your own.

There are however ways how you can change the prompt from SQL> to something you like,
for example time, ORACLE_SID, schema, like 10:41:02 SID SYSTEM>
You might want to read about glogin.sql file. Details will depend on your operating system.

regards

PS:

Not sure if all that will work for an idle instance too.

But you might want to try it out!

Message was edited by: Joe Bo.