Dynamic update statement ......

From: agichen <agi_at_feib.com.tw>
Date: Sun, 01 Aug 1999 19:13:49 -0800
Message-ID: <933563633.287_at_www.remarq.com>

[Quoted] Hello, theres,

   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??
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!
Received on Mon Aug 02 1999 - 05:13:49 CEST

Original text of this message