Oracle中delete,truncate和drop的区别
Truncate删除表中的所有数据, 这个操作不能回滚,也不会触发这个表上的触发器,TRUNCATE比delete更快,占用的空间更小。
Drop命令从数据库中删除表, 所有的数据行,索引和权限也会被删除,所有的DML触发器也不会被触发,这个命令也不能回滚。
【Oracle中delete,truncate和drop的区别】相关文章
1. Oracle中delete,truncate和drop的区别
2. 软件测试LoadRunner面试题:What is correlation? Explain the difference between automatic correlation and manu
3. 软件测试LoadRunner面试题:What is the difference between Overlay graph and Correlate graph?
5. 软件测试LoadRunner面试题: Where do you set automatic correlation options?
6. 软件测试LoadRunner面试题:What is the difference between standard log and extended log?
7. 软件测试LoadRunner面试题:If you want to stop the execution of your script on error, how do you do that?
8. What\'s the difference between deep copy and shallow copy? (深拷贝与浅拷贝有什么区别)
9. 介绍一下ICMP(Internet Control Message Protocol)Internet控制信息协议
10. 软件测试LoadRunner面试题:Explain the following functions: – lr_debug_message
本文来源:https://www.mianshiwenti.com/a13257.html
﹝Oracle中delete,truncate和drop的区别﹞相关内容
- 软件测试LoadRunner面试题:What is a function to capture dynamic values in the web vuser script?
- 软件测试LoadRunner面试题:If web server, database and Network are all fine where could be the problem?
- What\'s the difference between Debug and Trace class? (Debug类与Trace类有什么区别)
- What\'s the difference between an interface and abstract class? (接口与抽象类有什么区别)
- 软件测试LoadRunner面试题:How do you identify the performance bottlenecks
- 软件测试LoadRunner面试题:How did you find web server related issues?
- Can a struct inherit from another struct? (结构体能继承结构体吗)
- How to detect and cleanup pending transactions in Oracle
- 若通过ObjectOutputStream向一个文件中多次以追加方式写入object,为什么用ObjectInputStream读取这些object时会产生StreamCorruptedExcepti
- System.Array.CopyTo()和System.Array.Clone()有什么区别