Oracle trigger

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 Thu Aug 16 2001 - 09:31:51 CDT