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


Oracle LazyDBA home page