https://tajuddin.chittagong-it.com/create-trigger-to-set-column-value-depending-on-another-table-column-value-in-oracle-database/