SELECT NAME FROM SYS.GV_$DATABASE;
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From: Ghadge,Sameer [SMTP:[EMAIL PROTECTED]]
Sent: Tue, February 12, 2002 11:53 AM
To: Multiple recipients of list ORACLE-L
Subject: V_$SESSION question
Hi,
Ghadge,Sameer wrote:
Hi,
my problem is as follows:
I want do determine the machine name (and other info) from pl/sql,of the
client from which i have logged in
e.g. suppose i have logged from machine 'power_machine' as user 'puser'
my pl/sql has info. that the current user 'puser'
A quick and easy way, though there may be better or even easier ways that
the list will no doubt tell us about..
select distinct sid from v$mystat;
HTH
Mark
-Original Message-
Ghadge,Sameer
Sent: 12 February 2002 09:53
To: Multiple recipients of list ORACLE-L
Hi,
my problem is as
Hi
If you whant the information in the session you can use the function
SYS_CONTEXT ('USERENV', attribute)
attribute := 'host' or 'ip_address' or some other of the 25 options
look in the Oracle8i SQL Reference
chapter 4
Ghadge,Sameer wrote:
Hi, my problem is as follows:I want do
:
Sent by: Subject: RE: V_$SESSION question
root@fatcity