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> wrote: > > and you can get all of those things from the dataabse itself anyway > > On 2/1/06, Alex Gorbachev <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 onkarnath.tiwary@xxxxxxxxx