How to find Oracle path

SQL Experts => How to find Oracle path

 

question:
-----------------------------------------------------------
Hi,
How do we find Oracle Path (ORACLE_HOME) directory at the SQL prompt in wondows???

Thanks,
SindhuReddy

-----------------------------------------------------------
answer1:

On Windows:

SQL> host echo %ORACLE_HOME%
E:\oracle\app\oracle\product\10.2

On 10g as SYS:

SQL> var v_value char(70);
SQL> exec dbms_system.get_env('ORACLE_HOME', :v_value);
SQL> print v_value;

V_VALUE
--------
E:\oracle\app\oracle\product\10.2

-----------------------------------------------------------
answer2:

Hi,
Thanx for ur quick reply..But It does't work .Im using 9.2 version & windowa XP.
so pls do let me know the alternate way.

Thanks,

[Updated on: Wed, 13 December 2006 13:42]

-----------------------------------------------------------
answer3:

If SQL> host echo %oracle_home% didn't produce any results, then you probably don't have it specificially defined in your environement variable.

You could also use:

select substr(file_spec, 1, instr(file_spec, '\', -1, 2) -1) ORACLE_HOME
	from dba_libraries
	where library_name = 'DBMS_SUMADV_LIB';

[Updated on: Wed, 13 December 2006 13:56]

-----------------------------------------------------------
answer4:

Your last query will not work on 10g XE. It returns a non-existing directory (maybe the ORACLE_HOME of the original developer?)

-----------------------------------------------------------

SQL Experts => Merge the Result of tw ...
question:Hello, I have a table which is like this Car Typ Time BMW 330 13:00 BMW 335 11:00 BMW 320 16:00 Audi A4 12:00 Audi A5 16:00 Audi A6 15:00 I want t ...
SQL Experts => 2 inner queries in sel ...
question:I have 2 inner queries in my select statement. The most inner query I need to use the most outer query info in the where clause. I then want to order by a certain column. Then the query above ...
SQL Experts => UPDATE ERRO ORA-00933 ...
question:HI: I'm getting "Error ORA-00933, SQL Command not properly ended " at the line w/t "FROM" statement in the SQL below. I'm using Oracle 9.2.0.5 What am I doing wrong here update test1 a se ...
SQL Experts => column value as column ...
question:I need to get the column value as column name for pivot query. For a single id, you may have different dates and for every date there is a different amount. ex: ID rdate amount 1 ...
SQL Experts => Oracle 9i client insta ...
question:Hi all, One of the user getting the following error when tries to install oracle 9i client using Oracle Universal Installer. "Error writing to the directory C:\Documents and Settings\xxxx\L ...