Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: simple trigger problem ?

Re: simple trigger problem ?

From: norab <norab_at_digibel.org>
Date: 2000/05/08
Message-ID: <pjBR4.171454$uF1.379377@afrodite.telenet-ops.be>#1/1

> On the other hand if the
> customer table only has a pointer to the address table then the change
> of the address will not require any change to A. In this case if you
> want to know who is affected by the address change just build an index
> on the FK address column in A and query on it.

This is the case.
and indeed i want to know who is affected by the adress change. but i dont know how i have to do that
and i have no experience with building indexes :/

is it possible to describe what i have to do exactly ?

it would help me ALOT
tnx man

norab. Received on Mon May 08 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US