title: Altering more than one column in a table in oracle
body: <p>Will the two scripts below (for altering a table) make diff..??</p>
  
  <p><strong>script 1 :</strong></p>
  
  <pre><code>alter table ACNT_MGR_HSTRY add DM_BTNUMBER DATA_TYPE ;
  alter table ACNT_MGR_HSTRY add DM_BTID DATA_TYPE ;
  alter table ACNT_MGR_HSTRY add DM_USERID DATA_TYPE ;
  alter table ACNT_MGR_HSTRY add DM_WSID DATA_TYPE ;
  </code></pre>
  
  <p><strong>script 2 :</strong></p>
  
  <pre><code>alter table  ACNT_MGR_HSTRY
  add
  (
  DM_BTNUMBER DATA_TYPE,  
  DM_BTID DATA_TYPE,
  DM_USERID DATA_TYPE,
  DM_WSID DATA_TYPE
  );
  </code></pre>
  
  <p>will update makes a diff..???</p>
  
  <pre><code>update OPERATIONAL_UNIT
   set ( BANK_ID=
   ENTY_CODE_ID=
   TIME_ZONE=
   DM_BTNUMBER=
   DM_BTID=
   DM_USERID=
   DM_WSID=
   );
   -----------
   update OPERATIONAL_UNIT set BANK_ID=;
   update OPERATIONAL_UNIT set ENTY_CODE_ID=;
   update OPERATIONAL_UNIT set TIME_ZONE=;
   update OPERATIONAL_UNIT set DM_BTNUMBER=;
   update OPERATIONAL_UNIT set DM_BTID=;
   update OPERATIONAL_UNIT set DM_USERID=;
   update OPERATIONAL_UNIT set DM_WSID=;
  </code></pre>