From: kennedy-down_with_spammers@no_spam.comcast.net   
      
   "DP"  wrote in message   
   news:5781eab2.0309020207.78ac1542@posting.google.com...   
   > Is there any command exists as "commit transaction" ?   
   >   
   > begin transaction   
   > < DML1 stmts >   
   > begin transaction   
   > < DML2 stmts >   
   > rollback transaction   
   > commit transaction   
   >   
   > which set of DML will be commites to the database or none ?   
   Transactions start or end with commit or rollback. eg   
   commit;   
   dml;   
   dml;   
   dml;   
   commit;   
      
   or   
   commit;   
   dml;   
   dml;   
   ...   
   rollback;   
      
   AFAIK in Oracle anything after the commit is ignored as a label. eg commit   
   mytrans;   
   Jim   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)