Skip to Main Content

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!

QuickSQL - adding table name prefix to PK does not update the trigger

Skip MoreheadMar 4 2024

Set ‘Prefix primary keys with table name’ to yes.

Simple table TEST with NAME field and audit cols.

ID col gets set correctly with table name - TEST_ID.

Check/set for ID in trigger does not have the prefix, only the column name ID.

Not a big deal with one table. I have a model with 20 tables and it's a very big deal to have to fix up the triggers.

Comments
Post Details
Added on Mar 4 2024
0 comments
145 views