THanks a Ton Satish,
u guys are great!
-----Original Message-----
From: Perikala Satish
[mailto:oracledba-ezmlmshield-x21566775.[Email address protected]
Sent: Wednesday, August 04, 2004 2:15 PM
To: LazyDBA Discussion
Subject: RE: How to know the o/s for a remote database
Or you can directly use the following query
SQL> select dbms_utility.port_string
2 from dual;
PORT_STRING
------------------------------------------------------------------------
--
HP9000/800-64.0.8.1.0
Regards,
Satish
-----Original Message-----
From: Satheesh
[mailto:oracledba-ezmlmshield-x72389790.[Email address protected]
Sent: Wednesday, August 04, 2004 11:31 AM
To: LazyDBA Discussion
Subject: RE: How to know the o/s for a remote database
in remote system db create function like,
create or replace function port_string return varchar2 as
lv_port varchar2(2000);
begin
select dbms_utility.port_string
into lv_port
from dual;
return lv_port;
end;
/
Function created.
in local system
SQL> select [Email Address Removed] from dual;
SVR4-be-64bit-8.1.0
Thanks and Regards,
Satheesh Babu.S
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
"DISCLAIMER: PLEASE NOTE "change in our mail id. It has changed from
@hpsglobal.com to @pstsi.com".The information in this message is
confidential and may be legally privileged. It is intended solely for the
addressee. Access to this message by anyone else is unauthorised.If you are
not the intended recipient, any disclosure, copying, or distribution of the
message, or any action or omission taken by you in reliance on it,is
prohibited and may be unlawful. Please immediately contact the sender if
you have received this message in error. Thank you."
Oracle LazyDBA home page