Re: About HASH VALUE

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 20 Aug 2006 12:17:23 -0700
Message-ID: <1156101443.634431@bubbleator.drizzle.com>

Raaj wrote:
> Hi,
> I have some basic doubts. Please clarify me.
>
> 1) Will the Hash Value for select * from emp and select * from EMP is
> same.
> 2) Can be instance name and database name same.
> 3) Can we install different versions of Oracle under Oracle_Home
> Directory..
>
> Thanks,
> Raaj

Why would you ask this question when in less time you can find out?

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Aug 20 12:13:23 2006

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> SELECT ora_hash('select * from emp') from dual;

ORA_HASH('SELECT*FROMEMP')

---

                 3677333291

SQL> ed
Wrote file afiedt.buf

   1* SELECT ora_hash('select * from EMP') from dual SQL> / ORA_HASH('SELECT*FROMEMP')

---

                  125473356

SQL> Again why didn't you look?

SQL> SELECT database_name

   2 FROM gv$database;

DATABASE_NAME

---

ORABASE.REGRESS.RDBMS.DEV.US.ORACLE.COM SQL> SELECT instance_name

   2 FROM gv$instance;

INSTANCE_NAME

---

orabase

SQL> Though I suspect you were actually referring to the SERVICE NAME as in the TNSNAMES.ORA which can be the same and usually is.

Each version must be in its own ORACLE_HOME and pointed to by the ORACLE_HOME environment variable when being referenced.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Sun Aug 20 2006 - 14:17:23 CDT