Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle trigger
From the top level (8.1.x) documentation page select:
Server Application Development
From the Application Development page select:
Oracle8i Application Developer’s Guide - Fundamentals
Chapter/Section 12 has what you need.
hth,
Gene Hubert
Durham, NC
lharris_at_maih.com (lharris) wrote in message news:<c22af497.0108160631.1eb4c4bb_at_posting.google.com>...
> I'm new to the database development environment and I need to create a
> trigger to be used on inserts and updates. I understand the basic
> premis of this; however, I need to update a row in table B based on
> information in Table A and Table C:
>
> Basically here's the situation
> Table A will be updated with a new row.
> I need to check the values of the new row in Table A once the row has
> been inserted.
> Question 1:
> I do not know how to capture this new row's primary key value - How do
> I do this?
>
> Once I have the primary key from Table A then I can link everything to
> Table B, but I also have to check a value in Table C and I need to
> know how to capture this current row as well.
>
> Question 2:
> If those values meet my criteria, then I need to update information in
> Table B after the corresponding row for Table B is inserted. How do I
> capture the value of that newly inserted row's primary key?
Received on Fri Aug 17 2001 - 09:03:36 CDT