Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Environment Variables inside Oracle Procedures?

Re: Environment Variables inside Oracle Procedures?

From: <fitzjarrell_at_cox.net>
Date: Thu, 06 Sep 2007 09:00:37 -0700
Message-ID: <1189094437.079892.56450@o80g2000hse.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US