Can Set transaction override autocommit in SQL*PLUS
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Can Set transaction override autocommit in SQL*PLUS

  1. #1
    Join Date
    Sep 2000
    Posts
    14

    Question Can Set transaction override autocommit in SQL*PLUS

    HI,

    Can I override autocommit( SET AUTOCOMMIT ON ) by setting a new transaction ( SET TRANSACTION) in SQL* Plus??

    if not , are there any other ways I can override autocommit
    apart from turing it off. Can anyone help!

    mcl

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    I believe you can leave it off (if you want), then perform a transaction starting with Set Transaction .... and then commit when done.

  3. #3
    Join Date
    Sep 2000
    Posts
    14
    Thanks for your reply. After some experiments it seems that by starting a new transaction will not override the autocommit
    setting.

    SQL> set autocommit on
    SQL> set transaction read write
    2 ;

    Transaction set.

    SQL> update test set col1= 'TEST'
    2 /

    2 rows updated.

    Commit complete.
    SQL>



    Do you know another way of turning off autocommit apart
    from SET AUTOCOMMIT OFF?

    mcl


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width