Variable for column name

I would like to use a variable for a column name in a trigger that I'm writing.

For example I have:

   SELECT field_name
   INTO v_field_name
   FROM field_table;

What I want to do is use the v_field_name as follows:

 UPDATE new_table
   SET v_field_name = :NEW.udf

However, this doesn't work. Any help would be appreciated. Thanks,
Dan

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 26 1999 - 17:04:43 CDT