Re: How to use Column name in trigger

One solution would be to compare the variable to each of the column names.

        if column_variable = 'COL1' then
            do COL1 stuff
        elsif column_variable = 'COL2' then
            do COL2 stuff


         .

         .

         .

         end if;