RE: return hostname in PL/SQL

From: Brian MacLean <bmaclean_at_homebid.com>
Date: Tue, 23 May 2000 08:21:35 -0700
Message-Id: <10506.106380@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01BFC4CA.95791DA6
Content-Type: text/plain;

charset="windows-1252"

In v8.1.5 the column HOST_NAME is on the table v$instance. Just do a "select...Into...;" to get it PL/SQL.

-----Original Message-----
From: John Dunn [mailto:john.dunn_at_sefas.co.uk] Sent: Tuesday, May 23, 2000 2:56 AM
To: Multiple recipients of list ORACLE-L Subject: return hostname in PL/SQL

How can I get hold of the machine hostname via PL/SQL?

John

-- 
Author: John Dunn
  INET: john.dunn_at_sefas.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).

------_=_NextPart_001_01BFC4CA.95791DA6
Content-Type: text/html;
	charset="windows-1252"
Content-Transfer-Encoding: quoted-printable



<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">

<HTML>

<HEAD>

<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Dwindows-1252">


<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =

5.5.2448.0">


<TITLE>RE: return hostname in PL/SQL</TITLE>

</HEAD>

<BODY>




<P><FONT SIZE=3D2>In v8.1.5 the column HOST_NAME is on the table =

v$instance.&nbsp; Just do a &quot;select...Into...;&quot; to get it =
PL/SQL.</FONT>


</P>

<BR>

<BR>




<P><FONT SIZE=3D2>-----Original Message-----</FONT>

<BR><FONT SIZE=3D2>From: John Dunn [<A =

HREF=3D"mailto:john.dunn_at_sefas.co.uk">mailto:john.dunn_at_sefas.co.uk</A>]<=
/FONT>


<BR><FONT SIZE=3D2>Sent: Tuesday, May 23, 2000 2:56 AM</FONT>

<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>

<BR><FONT SIZE=3D2>Subject: return hostname in PL/SQL</FONT>

</P>

<BR>




<P><FONT SIZE=3D2>How can I get hold of the machine hostname via =

PL/SQL?</FONT>


</P>




<P><FONT SIZE=3D2>John</FONT>

</P>

<BR>

<BR>




<P><FONT SIZE=3D2>-- </FONT>

<BR><FONT SIZE=3D2>Author: John Dunn</FONT>

<BR><FONT SIZE=3D2>&nbsp; INET: john.dunn_at_sefas.co.uk</FONT>

</P>




<P><FONT SIZE=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) =

538-5051&nbsp; FAX: (858) 538-5051</FONT>


<BR><FONT SIZE=3D2>San Diego, =

California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet =
access / Mailing Lists</FONT>


<BR><FONT =

SIZE=3D2>---------------------------------------------------------------=
-----</FONT>


<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =

E-Mail message</FONT>


<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =

'ListGuru') and in</FONT>


<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =

ORACLE-L</FONT>


<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =

from).&nbsp; You may</FONT>


<BR><FONT SIZE=3D2>also send the HELP command for other information =

Received on Tue May 23 2000 - 10:21:35 CDT