Thursday, May 02, 2013

ora_is_alter_column

System triggers cannot be based on tables or views. So this is what I relearned today after I executed the pl\sql challenge question. after alter trigger is a system trigger and it can not be created on a table.

ora_is_alter_column is a function which can be used in trigger to compare column being altered to a column name.