Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Environment Variables inside Oracle Procedures?
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 Received on Thu Sep 06 2007 - 11:00:37 CDT