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@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


Other related posts: