开发者社区> 问答> 正文

statements in PL/SQL?

已解决

What are COMMIT, ROLLBACK and SAVEPOINT statements in PL/SQL?

展开
收起
1780169608831412 2021-10-16 18:07:08 645 0
1 条回答
写回答
取消 提交回答
  • 网络规划设计师、敏捷专家、CISP、ITSS服务经理、ACA全科目、ACP4项、ACE、CBP、CDSP、CZTP等。拥有 PRINCE2 Foundation/Practitioner、CCSK、ITIL、ISO27001、PMP等多项国际认证。 专利5+、期刊10+、知识产权师。核心期刊审稿人。
    采纳回答

    These are the three transaction specifications that are available in PL/SQL.

    COMMIT: Whenever any DML operations are performed, the data gets manipulated only in the database buffer and not the actual database. In order to save these DML transactions to the database, there is a need to COMMIT these transactions. COMMIT transaction action does saving of all the outstanding changes since the last commit and the below steps take place:

    The release of affected rows.
    The transaction is marked as complete.
    The details of the transaction would be stored in the data dictionary.
    
    
    Syntax: COMMIT;
    
    

    ROLLBACK: In order to undo or erase the changes that were done in the current transaction, the changes need to be rolled back. ROLLBACK statement erases all the changes since the last COMMIT.

    Syntax: ROLLBACK;
    
    

    SAVEPOINT: This statement gives the name and defines a point in the current transaction process where any changes occurring before that SAVEPOINT would be preserved whereas all the changes after that point would be released.

    Syntax: SAVEPOINT <savepoint_name>;
    
    2021-10-16 18:25:03
    赞同 2 展开评论 打赏
问答分类:
问答标签:
问答地址:
问答排行榜
最热
最新

相关电子书

更多
SQL Server在电子商务中的应用与实践 立即下载
GeoMesa on Spark SQL 立即下载
原生SQL on Hadoop引擎- Apache HAWQ 2.x最新技术解密malili 立即下载