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

Home -> Community -> Usenet -> c.d.o.tools -> Re: PL/SQL: get ORACLE_SID?

Re: PL/SQL: get ORACLE_SID?

From: Andrew Hardy <Andrew.Hardy_at_AdvanticaTech.com>
Date: Fri, 15 Dec 2000 13:55:05 -0000
Message-ID: <91d7re$q5f$1@sun-cc204.lut.ac.uk>

You could have a look at v$parameter - there's a db_name, service_names in there.

Andy
Jan Haase <jh_at_informationsdesign.de> wrote in message news:3A3A0356.35E6CE6C_at_informationsdesign.de...
> Hi.
>
> In one of my scripts I need to check the username and ORACLE_SID to be
sure that the following create table statements don't go into the wrong database.
> Is there a possibility to get the value of these variables - or any
 environment variables in a pl/sql-script?
>
> Thanks in advance,
> Jan
Received on Fri Dec 15 2000 - 07:55:05 CST

Original text of this message

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