Re: running os command from pl/sql block
- From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
- To: davidsharples@xxxxxxxxx
- Date: Wed, 01 Feb 2006 12:07:25 +0100
David Sharples wrote:
SQL> select dbms_utility.port_string from dual;
PORT_STRING
--------------------------------------------------------------------------------
Linuxi386/Linux-2.0.34-8.1.0
On 2/1/06, *Stephane Faroult* <sfaroult@xxxxxxxxxxxx
<mailto:sfaroult@xxxxxxxxxxxx>> wrote:
The only place I know where you can get the OS is V$VERSION, where
banner like 'TNS%'. Unfortunately, you won't get the exact
version, but
it can be enough if all you want is differentiate Windows from various
Unix flavours.
Good one. I learned something new today.
Stéphane Faroult
--
http://www.freelists.org/webpage/oracle-l
- Follow-Ups:
- Re: running os command from pl/sql block
- From: David Sharples
- References:
- running os command from pl/sql block
- From: Onkar N Tiwary
- Re: running os command from pl/sql block
- From: Alex Gorbachev
- Re: running os command from pl/sql block
- From: David Sharples
- Re: running os command from pl/sql block
- From: Onkar N Tiwary
- Re: running os command from pl/sql block
- From: Stephane Faroult
- Re: running os command from pl/sql block
- From: David Sharples
Other related posts:
- » running os command from pl/sql block
- » Re: running os command from pl/sql block
- » RE: running os command from pl/sql block
- » Re: running os command from pl/sql block
- » Re: running os command from pl/sql block
- » Re: running os command from pl/sql block
- » Re: running os command from pl/sql block
- » Re: running os command from pl/sql block
- » Re: running os command from pl/sql block
- » Re: running os command from pl/sql block
- » RE: running os command from pl/sql block
- » Re: running os command from pl/sql block
- » Re: running os command from pl/sql block
- » RE: running os command from pl/sql block
- » Re: running os command from pl/sql block
- » RE: running os command from pl/sql block
- » RE: running os command from pl/sql block
- » RE: running os command from pl/sql block
- » RE: running os command from pl/sql block
- » Re: running os command from pl/sql block
- » RE: running os command from pl/sql block
- » Re: running os command from pl/sql block
- » Re: running os command from pl/sql block
SQL> select dbms_utility.port_string from dual;
PORT_STRING -------------------------------------------------------------------------------- Linuxi386/Linux-2.0.34-8.1.0
On 2/1/06, *Stephane Faroult* <sfaroult@xxxxxxxxxxxx <mailto:sfaroult@xxxxxxxxxxxx>> wrote:
The only place I know where you can get the OS is V$VERSION, where
banner like 'TNS%'. Unfortunately, you won't get the exact
version, but
it can be enough if all you want is differentiate Windows from various
Unix flavours.Good one. I learned something new today.
- Re: running os command from pl/sql block
- From: David Sharples
- running os command from pl/sql block
- From: Onkar N Tiwary
- Re: running os command from pl/sql block
- From: Alex Gorbachev
- Re: running os command from pl/sql block
- From: David Sharples
- Re: running os command from pl/sql block
- From: Onkar N Tiwary
- Re: running os command from pl/sql block
- From: Stephane Faroult
- Re: running os command from pl/sql block
- From: David Sharples