Shulou(Shulou.com)05/31 Report--

This article mainly introduces "what are the ways in which transactions are generated by oracle". In daily operation, I believe many people have doubts about the methods in which transactions are generated by oracle. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts about "what are the methods for oracle to generate transactions?" Next, please follow the editor to study!

Several methods of generating transactions

Dml uncommitted generated transaction

Select for update generate transaction

Set transaction generate transaction

Dbms_transaction generate transaction

Sample code

Dml uncommitted transaction

SQL > create table t_tran (an int); Table created.SQL > insert into t_tran select 1 from dual 1 row created.SQL > col sql_text for a50SQL > set linesize 300 SID TADDR SQL_ID PREV_SQL_ID SQL_TEXT-- -50 0000000084201938 2un55p68csz4r insert into t_tran select 1 from dual

Select for update generate transaction

SQL > select * from t_tran for update A-1 SQL > / SID TADDR SQL_ID PREV_SQL_ID SQL_TEXT-- -- 50 0000000084201938 gmd5z3754t8km select * from t_tran for update

Set transaction generate transaction

SQL > set transaction name 'tran1';Transaction set.SQL > select * from t_tran A-1SQL > / SID TADDR SQL_ID PREV_SQL_ID SQL_TEXT-- -- 50 0000000084201938 3rfg8vk38qhcq select * from t_tran

Dbms_transaction generate transaction

SQL > exec dbms_transaction.read_only PL/SQL procedure successfully completed.SQL > / SID TADDR SQL_ID PREV_SQL_ID SQL_TEXT -50 0000000084201938 7j2qb5qfzk4hu BEGIN dbms_transaction.read_only At this point in END;, the study of "what are the ways in which oracle generates transactions" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.