Truncate | Delete | |
1 | It is DDL(Data Definition Language) Statement. | It is DML(Data Manipulation Language) Statement. |
2 | It Delete all rows from table. | You Can Delete All rows as well as specified rows using Delete. |
3 | You can not Rollback all raw. | Using Rollback you can retrieve all rows from the point of last commit. |
4 | It release all raw including Memory space, Just Structure remains there. | It delete all raw but, not Memory space. |
5 | Example : Truncate Table Emp | Example : Delete From Emp Where Empno=7369 |
Privacy Policy
-
Privacy Policy Effective date: March 08, 2019
PLSQL ("us", "we", or "our") operates the mobile application (the
"Service").
This page informs you of our po...
5 years ago
0 comments:
Post a Comment