fitzjarrell_at_cox.net wrote:
> On Sep 5, 8:24 pm, Brian Peasland <d..._at_nospam.peasland.net> wrote:
>> Why not query from V$INSTANCE? That will tell you the SID and the
>> hostname. From that, you should be able to deduce whether you are on
>> prod or dev.
>>
>
> One would hope. :)
>
>
> David Fitzjarrell
Just as a point-of-view ... giving access to v$instance might be a
security issue. Giving access to SYS_CONTEXT might be more acceptable.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Sep 07 2007 - 11:42:15 CDT
