| 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...
6 years ago

0 comments:
Post a Comment