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: how to get database name using sql statements

Re: how to get database name using sql statements

From: Noodles <noodles_at_aol.com>
Date: 27 Nov 1999 15:25:57 GMT
Message-ID: <19991127102557.15060.00000783@ng-fm1.aol.com>

How about:

select global_name from global_name;

if you don't mind the whole string. You can substr out the ORA_SID if that's all you want.

Just my 2 Cents. Received on Sat Nov 27 1999 - 09:25:57 CST

This message: [ Message body ]
Next message: Jacques Maritz: "Re: limit clause of a select command"
Previous message: fumi: "A bug on RAWTOHEX function"
In reply to: Fritz: "Re: how to get database name using sql statements"
Next in thread: Nisar Tareen: "Re: how to get database name using sql statements"
Reply: Nisar Tareen: "Re: how to get database name using sql statements"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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