I am trying to create a trigger on table A. This trigger is fired when table
A is updated. At the same time I need to delete the relative record in
another Table B which has no direct link to A but has link through table C.
Thanks

I have two machine, one with Oracle 8.1.... server on windows. The
other with Linux and I'm trying to connect via c++ to the oracle
server. I've downloaded all the library needed anf I can compile the
program, but when I run it and try to connect I receive the infamous:

I have an application whose database was recently upgraded from 7 to 9i. In
a bit of code, columns are compared that may both be null. In Oracle 7,
will two columns compare equal if they are both NULL? In 9i it seems that
they do not and I have to change it to NVL(column1) = ...

I get Input/output error when I run  runInstaller on linux ES4.
I do not what is the problem can anybody help me with this ?
thanks

I have been placed in charge of looking for a unified command for UNIX
to ennumerate all of the versions of Oracle database as well as the
options/softwares that are associated with it.  We have a variety of
Oracle versions and was wondering if there is a simple command or

I'm trying to install CRS on a 2-node-cluster consisting of HP servers
and HP FC SAN, on Windows 2003 Standard.
Network interfaces are configured like described at the RAC
documentation (one public, one private interface; different subnets,

I have a table in a data warehouse which has reached its limit for
autogenerated primary key - a signed 32 bit integer which can be a
decimal number from -2147483648 to 2147483647 (I use Informatica
PowerCenter, ETL tool, which creates it like that).

I'm a bit confused about the result of tz_offset in oracle.
I don't understand the result of this query
SELECT tz.*, tz_offset(tz.tzname) DIFF
FROM V$TIMEZONE_NAMES tz WHERE TZNAME IN

Searched the web and other groups a lot. But unable to get a right way
of doing this.
I am having the execution plan of a query. Now i want to validate
whether the figures given in that are valid or not, like the Rows,

I like it ! Better overview and seems to be faster too.
However, too bad they replaced the word "TAR" by "Service Request". I will
miss it :-)
Matthias

Why can't I use owa_pattern.pattern as a column type?
SQL> create table temp(
 2      names owa_pattern.pattern
 3  ) nested table names store as temp_names;

Is there a text log that keeps track of RMAN commands and results?  If
so, where is it normally located?

I have one client 10g server on my office computer, which I use when
the regular servers are down .I also have 10g client. Both have a
TNSNAMES.ORA, and its not clear to me that it needs two of these files
to work properly. I seem to have to update both, using the net manager,

   I was able to solve the following problem using PL/SQL. However I
would like to know if it can be solved using a SQL query:
     The table has these columns:    user_id, purchase_date
     I would like to count the number of store visits by a person

I tried to build an index like:
CREATE TABLE A
(
  TS  TIMESTAMP(3) WITH LOCAL TIME ZONE