Dynamic update statement ......

   I have a table A with 41 columns, the table's layout    as follows

   op_date date,

   N1       varchar2(1),    /* flag column */
   N2       varchar2(1),
   N3       varchar2(1),
   .....
   N40      varchar2(1)

   I want to update the flag column Nx determined by    the value stored in TABLE B,
   B's layout is

   op_date date,

   n1     number(2),
   n2     number(2),
   n3     number(2),
   n4     number(2)

For example,
  if B has a record 1999/08/01,3,5,7,9
  then the table A should have the record

  1998/08/01,0,0,1,0,1,0,1,0,1,0,0......0   just set the 3rd,5th,7th,9th flag to 1 How to write the code to dynamic update table A according to the values stored in B ??

Any idea??
Rgds,
Agi Chen

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!