Re: ORA_SID in Sql*Plus?

rem /*********************************************************************
rem *
rem *   login.sql - sqlplus start up file
rem *
rem *   When sqlplus starts up, it runs login.sql; if it finds it in
rem *   the SQLPATH environment variable.
rem *
rem *   next four statements sets the sql prompt = oracle instance.

rem *********************************************************************/
 

column sid new_value osid noprint
select lower (substr (global_name, 1, (instr (global_name, '.') -1))) sid from global_name ;
set sqlprompt '&osid> '

Frenchy461 (frenchy461_at_aol.com) wrote: : select * from v$database;

--
This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.