关于回滚的疑问 [英] doubt regarding rollback

问题描述

大家好，


我想检查truncate和delete命令之间的区别。我知道它们之间的区别，即。，truncate是DDL，delete是DML语句。删除可以回滚知道，但我尝试了但它没有用。


我试过这个命令

展开 | 选择 | Wrap | 行号

解决方案

首先你应该开始交易


1.开始

2。 UPDATE员工SET名=''arun''WHERE id = 1;

3. ROLLBACK;

大家好，


我想检查截断和删除逗号之间的区别ND。我知道它们之间的区别，即。，truncate是DDL，delete是DML语句。删除可以回滚知道，但我尝试了但它没有用。


我试过这个命令

展开 | 选择 | Wrap | 行号

我认为您的UPDATE语句没有进行任何更新，这是ROLLBACK向您显示的原因警告。检查您的更新语句更新表中的任何记录，然后尝试执行ROLLBACK

感谢它正在运行，但我遇到的问题是，当我截断表然后执行r时ollback命令它不应该回滚但它正在回滚，并且我执行回滚命令之后表中的数据就在那里......

展开 | 选择 | Wrap | 行号

Hi all,

I want to check the difference between the truncate and delete command. I know the difference between them ie., truncate is DDL and delete is DML statement. Delete can be rollbacked know but i tried it but it does not work out.

I tried this command

Expand|Select|Wrap|Line Numbers

解决方案

First u should begin a transaction

1. BEGIN
2. UPDATE employee SET name=''arun'' WHERE id=1;
3. ROLLBACK;

Hi all,

I want to check the difference between the truncate and delete command. I know the difference between them ie., truncate is DDL and delete is DML statement. Delete can be rollbacked know but i tried it but it does not work out.

I tried this command

Expand|Select|Wrap|Line Numbers

I think Your UPDATE statement is not doing any update that is the reason ROLLBACK is showing you WARNING.Check whether your update statement updates any record in the table and then try doing ROLLBACK

Thanks it is working but I am having a problem that is when I truncate a table and then executing rollback command it should not be rollbacked but it is getting rollbacked and the datas in the table are there after i execute rollback command......

Expand|Select|Wrap|Line Numbers

这篇关于关于回滚的疑问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！