Re: Table that contains the Oracle_SID of the database ?
From: David R. Thrash <dthrash_at_sbctri.sbc.com>
Date: 19 Jun 1993 22:05:56 GMT
Message-ID: <2002k4$62j_at_sbctri.sbc.com>
Date: 19 Jun 1993 22:05:56 GMT
Message-ID: <2002k4$62j_at_sbctri.sbc.com>
In article <1993Jun17.040058.29614_at_cmutual.com.au> Tony Cook,
btc_at_cmutual.com.au writes:
>--
Here's what I use in V6 :
create view sid (id) as
select value from v$parameter where name = 'db_name'
/
grant select on sid to public
/
create public synonym sid for sid
/
Received on Sun Jun 20 1993 - 00:05:56 CEST