Skip to Main Content

Oracle Database Discussions

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!

How to Create a Trigger

869358Jun 16 2011 — edited Jun 16 2011
I am using Oracle SQL Developer Data Modeler, and am looking to create insert triggers. How do I fill out the Trigger Properties window? For instance, when a value is entered on table 1, but its not an option on table 2, I want the trigger to insert "NA". How is this done?

Thanks! Any help is appreciated!

Comments

SH_INT
Answer

If it is a question of just assigning HSP_NOLINK to an Account just use the Account as the Source and map the UDA based on that value

Marked as Answer by 3047423 · Sep 27 2020
3047423

thanks for your reply.

i have added UDA extract column in target application and mapping for it in data loading mapping.

Thanks

Venkataraju saripella

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

Post Details

Locked on Jul 14 2011
Added on Jun 16 2011
1 comment
209 views