Path in Oracle SQL

[axmug]

Hi,

I'm working with Oracle 9i and I would like to know if there is a command to show operating system path and where I can find it.

Thanks.

 

[hoinz]

operating system path to what ?
What do you want to achieve?

 

[KenCunningham]

Is this unix? echo $PATH should tell you what it is. Post back with more info if that's not sufficient.

 

[axmug]

I'm sorry. Maybe I didn't explain what I'm looking for.

I'm working with an Oracle 9i database using Oracle Discoverer. Discoverer lets me to make querys in the database with a look with colors and so on.

What I would like to say is if there is a SQL command that returns the path. For example, there is a SQL command that return the system date (November 22, 2004 could be a result). What I want to say is if there is a SQL command that returns the following (it's an example):

c:\Windows\System

I'm working in Windows XP Professional.

Thanks.

 

[hoinz]

Ok, it's clearer now:

1) There is no SQL command to show operating system variables like %Path%.

2) Maybe Oracle Discoverer allows some other way to do it. I don't know Discoverer, sorry.
Sombody else might tell you.
Just a guess: In SQL*plus you could do 'host echo %Path%'
(Though the new window will disappear immediately)
Does this work in Discoverer?

regards