hi how can i swap column in this procedure i what to display sub_desc
this is my if statement
if r.column_id = 4 and r.column_name = 'SUB_DESC' then --- r.column_name = 'SUB_DESC' then :control.column3:= r.column_name; -- :control.column3 := 'SUB_DESC';
ELSE :control.column3:=r.column_name;
end if;
