With the oracle 10.2, the Oracle Universal Installer doesn't start on
my windows 2000 professional pentium III with java 1.4.2 installed.
A dos window apprears and nothing !
I think there is a problem with the JRE

Even though ROWNUM limits the data set fetched, does the server generate the
entire data set?
For example:
SELECT id

I am trying to create the servlet that searchs tables with the same
strcuture but on different DB( Oracle and MSSQL ) and get search result
based on the search condition specified. Currently I am going one by one to
through the SQL sentence and assemble the search result. However, ...

Good news for any who may have suffered hanging applications
because of Oracle's locking of logically unrelated data along
with the relevant data for any pending prepared XA transaction.
Oracle has removed the block-level locking:

i have a table like one shown below
start_date | end_date    | traveller
-----------------------------------------------
1/1/2005   |  10/10/2005 |   a

I have an app that is experiencing ORA-00907 and ORA-00911, both of
which relate to syntax errors in SQL statements (missing parentheses,
unquoted special characters etc). I don't want to switch on SQL tracing
globally, and I won't know which session generated the error until it's

Environment:
2 HPUX servers running 11.11 os
Clustering using ServiceGuard with Ext for RAC
Oracle 9iR2 (9.2.0.6.0) installed successfully on both nodes.

I'm trying to follow the 9i docs for "Manually Creating an Oracle Database".
Step 1
 Select a SID, create ORACLE_SID env var
Done

I need to add sqlplus to a pc of a customer which has client Oracle
8.1.7 installed
but unfortunately no sqlplus.
Since I have to do this remotely I ask if is it possible to simply copy

I work for an organization that takes inbound calls. Each call is
stamped with a time.
First, I'd like to just get a count of the number of calls that
occurred over a date range, grouped by time ranges. The time ranges

Hi! Can anybody explain why Oracle allows only INTEGERs for seconds in
the clause FOR UPDATE WAIT <n>? Why I cannot use 0.5 sec or 1.1 secs?
What would be the reason for such behavior and implementation? Thank
you.

I try to update the O_VALUE field in my ORDERS table using cursor
variables, here is what I did:
  c_ID    VARCHAR2(10);
  c_Value   NUMBER(3);

Is there an Oracle character function returning the number of occurances
of a substring in a string? INSTR() is close but not quite what I am
looking for.
Thanks,

I'm an oracle9.2/sql newbie.
Is it possible to make 1 query out of the 4 queries (see below) with for
example "group by" function?
I'm actually using 4 sql queries that counts the Last_name beginning with:

We're encountering many of "Global Enqueue Services Deadlock detected"
messages in the alert log of one of our database instances (two node
RAC database) together with quite big global cache cr request waits in
STATSPACK report. The problem is that the only other available