Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> multiple updates in one statement

multiple updates in one statement

From: Prasath <prasath.rao_at_gmail.com>
Date: 29 Jun 2006 06:08:01 -0700
Message-ID: <1151586481.211964.178130@p79g2000cwp.googlegroups.com>


Is it possible to merge the below 2 update statements into one single statement.

  1. update test_table set my_col = 1 where my_flag = 'N';
  2. update test_table set my_col = 2 where my_flag != 'N';
Received on Thu Jun 29 2006 - 08:08:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US