Re: running os command from pl/sql block

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_at_gmail.com
> <mailto:davidsharples_at_gmail.com>> wrote:
>
> and you can get all of those things from the dataabse itself anyway
>
>
> On 2/1/06, *Alex Gorbachev* <gorbyx_at_gmail.com
> <mailto:gorbyx_at_gmail.com>> 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_at_yahoo.com <mailto:to_onkar_at_yahoo.com>
> onkarnath.tiwary_at_gmail.com <mailto:onkarnath.tiwary_at_gmail.com>

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