In 9.2, in SQL*Plus
prompt &_connect_identifier
Alex.
(Thanks to Connor McDonald)
-----Original Message-----
From: Jose Luis Delgado [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 11, 2003 2:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: how can I see which database I am logged into without
Funny.
--- Mladen Gogala <[EMAIL PROTECTED]> wrote:
> How about:
>
> SELECT 'RUMPELSTILSKIN' FROM DUAL;
>
> That should be a good guess.
>
> --
> Mladen Gogala
> Oracle DBA
>
>
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]] On
> > Behalf Of Jose Luis Delgado
> > Sent: Thursday, September 11, 2003 4:38 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: how can I see which database I am
> logged into without
> >
> >
> > Can you try:
> >
> > select global_name from global_name;???
> >
> > compare it with your
> > select ora_database_name from dual
> >
> > Are they the same?
> >
> > HTH
> > JL
> >
> > --- David Wagoner <[EMAIL PROTECTED]>
> wrote:
> > > You might get some surprising results from
> SELECT ORA_DATABASE_NAME
> > > FROM DUAL; (see below). I have a DEV database
> cloned
> > > from Prod. and it still
> > > lists the Prod. DB name with that query. Where
> is
> > > it reading the name from?
> > > You can see that other queries produce the
> "correct"
> > > name.
> > >
> > >
> > > SQL> select instance_name from v$instance;
> > >
> > > INSTANCE_NAME
> > > ----------------
> > > dmedi01
> > >
> > > SQL> show parameter name;
> > >
> > > NAME TYPE
> > > VALUE
> > > ------------------------------------ -----------
> > > ------------------------------
> > > db_file_name_convert string
> > > db_name string
> > > dmedi01
> > > global_names boolean
> > > FALSE
> > > instance_name string
> > > dmedi01
> > > lock_name_space string
> > > log_file_name_convert string
> > > oracle_trace_collection_name string
> > > oracle_trace_facility_name string
> > > oracled
> > > plsql_native_make_file_name string
> > > service_names string
> > > dmedi01.arsenaldigital.com
> > >
> > > SQL> select ora_database_name from dual;
> > >
> > > ORA_DATABASE_NAME
> > >
> >
>
--------------------------------------------------------------
> > --------------
> > > ----
> > > PMEDI01.ARSENALDIGITAL.COM
> > >
> > >
> > >
> > > Best regards,
> > >
> > > David B. Wagoner
> > > Database Administrator
> > > Arsenal Digital Solutions
> > >
> > >
> > >
> > > -----Original Message-----
> > > Sent: Wednesday, September 10, 2003 10:00 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > How about SELECT ORA_DATABASE_NAME FROM DUAL;
> > >
> > > HTH
> > > GovindanK
> > >
> > > > select sys_context('USERENV','DB_NAME') from
> > > <anytable>;
> > > >
> > > > At 10:49 AM 9/10/2003 -0800, you wrote:
> > > >>hi.
> > > >>
> > > >>I think there was a dbms package to get some
> of
> > > >>the environment variables for a session, but I
> > > can't
> > > >>remember anyhting specific. If someone know
> what
> > > I'm
> > > >>talking about and has any details, please
> Email me
> > > or
> > > >>post here
> > > >>
> > > >>thanks
> > > >>
> > > >>Gene
> > > >
> > > > Wolfgang Breitling
> > > > Oracle7, 8, 8i, 9i OCP DBA
> > > > Centrex Consulting Corporation
> > > > http://www.centrexcc.com
> > > >
> > > >
> > > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: GovindanK
> > > INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services -- 858-538-5051
> > > http://www.fatcity.com
> > > San Diego, California -- Mailing list and
> web
> > > hosting services
> > >
> >
>
---------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send
> an
> > > E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of
> > > 'ListGuru') and in
> > > the message BODY, include a line containing:
> UNSUB
> > > ORACLE-L
> > > (or the name of mailing list you want to be
> removed
> > > from). You may
> > > also send the HELP command for other information
> > > (like subscribing).
> > >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! SiteBuilder - Free, easy-to-use web site
> design
> > software http://sitebuilder.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> > --
> > Author: Jose Luis Delgado
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> > San Diego, California -- Mailing list and
> web hosting services
> >
>
---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru')
> > and in the message BODY, include a line
> containing: UNSUB
> > ORACLE-L (or the name of mailing list you want to
> be removed
> > from). You may also send the HELP command for
> other
> > information (like subscribing).
> >
>
>
>
>
> Note:
> This message is for the named person's use only. It
> may contain confidential, proprietary or legally
> privileged information. No confidentiality or
> privilege is waived or lost by any mistransmission.
> If you receive this message in error, please
> immediately delete it and all copies of it from your
> system, destroy any hard copies of it and notify the
> sender. You must not, directly or indirectly, use,
> disclose, distribute, print, or copy any part of
> this message if you are not the intended recipient.
> Wang Trading LLC and any of its subsidiaries each
> reserve the right to monitor all e-mail
> communications through its networks.
> Any views expressed in this message are those of the
> individual sender, except where the message states
> otherwise and the sender is authorized to state them
> to be the views of any such entity.
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Mladen Gogala
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jose Luis Delgado
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
