ORA_SID in Sql*Plus?

From: Douglas Scott <dsscott_at_gte.net>
Date: 1996/10/22
Message-ID: <326D4918.3923_at_gte.net>#1/1

Does anyone know if there is a way to find out what database instance you're in from inside of Sql*Plus? I go in and out of 2 instances all day long (beta & production databases) and sometimes lose track of which one I'm in (especially after an interruption like a meeting). I could get out and come back in, but if there is someway to tell which instance it would be easier.

Douglas Scott
dsscott_at_gte.net Received on Tue Oct 22 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: Frenchy461: "Re: ORA_SID in Sql*Plus?"
Previous message: Sadru Fidai: "Forms 4.5 question, item Updateable property"
Next in thread: Frenchy461: "Re: ORA_SID in Sql*Plus?"
Reply: Frenchy461: "Re: ORA_SID in Sql*Plus?"
Reply: Mike Burke: "Re: ORA_SID in Sql*Plus?"
Reply: Mike Burke: "Re: ORA_SID in Sql*Plus?"
Reply: AMARENDRA B NETTEM: "Re: ORA_SID in Sql*Plus?"
Maybe reply: John Strange: "Re: ORA_SID in Sql*Plus?"
Reply: Rick Hibling: "Re: ORA_SID in Sql*Plus?"
Maybe reply: Gary Assa: "Re: ORA_SID in Sql*Plus?"
Maybe reply: Joel Garry: "Re: ORA_SID in Sql*Plus?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message