Re: ORA_SID in Sql*Plus?

In article dated Mon, 28 Oct 1996 09:40:42 -0800, Halina Monka (toyr002_at_ibm.net) wrote:
> column DBNAME new_value DB noprint
> select value dbname from v$parameter

But this only works if you can access this table. A person with a DBA role can but not your average user.

> where name='db_name';
> set sqlprompt '&&DB>';
> set term on
> set echo on

--
 _--_|\  John Verhoeven           Unix / Database Administrator Westrail
/      \              johnv_at_DIALix.oz.au / jverhoeven_at_westrail.wa.gov.au
*_.--._/
      v   "Smile! things could be worse... So I did... and they were..."