Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: PL/SQL: get ORACLE_SID?
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