Re: Updating column in same table after insert...
> I'd like a column (name) to reflect entry from two other columns (nameFirst and nameLast). I'm trying to do so via this trigger:
A design error. A basic job of a well designed table is to minimise redundancy, not increase it. For display purposes, consider a View that combines first & last names as desired.
Read about the basic principles of relational databases, eg at
http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch01.pdf
Subject
Views
Written By
Posted
3589
September 05, 2017 01:52PM
Re: Updating column in same table after insert...
1559
September 05, 2017 02:15PM
1125
September 05, 2017 02:34PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.