Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create Trigger to Insert Row Automatically

MAFinanceDev-OracleAug 13 2015 — edited Aug 13 2015

Hi Apex'ers

I'm trying to write some SQL code to create a trigger that will do the following: When a row is created on Table A, I want it to create a blank row on Table B.

I'm new and learning SQL, so here's what I've pieced together so far (which I'm sure is far from complete).  I'm hoping to get some help finishing this code to create a trigger.

CREATE TRIGGER trigger_table_a ON table_b
BEFORE

INSERT INTO
table_b
(column1,column2,column3)

Thanks for the help!

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 10 2015
Added on Aug 13 2015
#apex-discussions, #trigger
5 comments
281 views