Compare two rows

 rec1 testTable%ROWTYPE -- have substaniated this variable

How can I reference a column in the record dynamically?

eg:
  instead of using

      value1 := rec1.column1;
how can I use a variable instead of column1

  thisColumn varchar2 (30) := 'column1';   value1 := rec1(thisColumn);

  thisColumn := 'column4';
  value1 := rec1(thisColumn); Received on Sun Dec 04 2005 - 19:02:39 CST