Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Trigger: Insert if not exists?
Thx Flavio,
Exactly what I was looking for...
Happy Holidays,
Barry
"FC" <flavio_at_tin.it> wrote in message
news:PKrJ9.2255$ab2.65876_at_news1.tin.it...
> Hello Barry,
> I'd suggest you to put a referential constraint on the title_word table
(in
> this case a primary key) and then trap any error of the kind
> DUP_VAL_ON_INDEX inside the trigger, that is wrapping up the INSERT
> statement:
>
> create or replace trigger <my_trigger>
> ... bla bla bla ...
>
> begin
> ...
> begin
>
> INSERT INTO title_words
> bla bla bla;
>
> exception
> when DUP_VAL_ON_INDEX then
> null;
> when others then raise;
> end;
> ...
> end;
>
> It looks simple to me, but to you ?
>
> Bye,
> Flavio
>
>
>
>
>
> "Barry Prentiss" <thebear_at_NOSPAM.stanford.edu> wrote in message
> news:at5fqr$erd$1_at_news.Stanford.EDU...
> > Hi,
> > I am trying to devise a trigger that inserts an object_id and a list of
> the
> > object's title_words into a title_words table. I would like to avoid
> > duplicate rows by ensuring that, even if the same title_word occurs many
> > times, only one insert for that object_id/title_word pair will occur. Is
> > there a simple way to do this?
> > [Oracle 8i, PL/SQL]
> > Thx in Advance,
> > Barry Prentiss
> > Stanford University
> >
> >
>
>
Received on Tue Dec 10 2002 - 14:40:23 CST