FreeLists / oracle-l / Re: running os command from pl/sql block

[Stephane Faroult <sfaroult@xxxxxxxxxxxx>]

Onkar,

    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.

HTH

Stephane Faroult

Onkar N Tiwary wrote:

> thanx all of u. I just wanted to know that only as David said i can 
> get all of them from the db only but from db i can get the database 
> name,host name but don know where to / how to find the os on which the 
> db is running. If u can guide me then i will be thankful.
>
>  
> On 2/1/06, *David Sharples* <davidsharples@xxxxxxxxx 
> <mailto:davidsharples@xxxxxxxxx>> wrote:
>
>     and you can get all of those things from the dataabse itself anyway
>
>
>     On 2/1/06, *Alex Gorbachev* <gorbyx@xxxxxxxxx
>     <mailto:gorbyx@xxxxxxxxx>> wrote:
>
>         Oh, come on! It's a google question. Try searching "os command
>         from
>         pl/sql" - much faster response. 
>
>
>
>
> --
> Thanks & Regards,
> T. Onkar Nath
> OneAPPS Enterprise Technology Pvt. Ltd.
>        to_onkar@xxxxxxxxx <mailto:to_onkar@xxxxxxxxx>
>        onkarnath.tiwary@xxxxxxxxx <mailto:onkarnath.tiwary@xxxxxxxxx>



--
http://www.freelists.org/webpage/oracle-l