in Oracle
Q
How To Delete All Rows from a Table in Oracle?
✍: FYIcenter.com
A
If you want to delete all rows from a table, you have two options:
- Use the DELETE statement with no WHERE clause.
- Use the TRUNCATE TABLE statement.
The TRUNCATE statement is more efficient the DELETE statement. The tutorial exercise shows you a good example of TRUNCATE statement:
SELECT COUNT(*) FROM fyi_links;
COUNT(*)
----------
3
TRUNCATE TABLE fyi_links;
Table truncated.
SELECT COUNT(*) FROM fyi_links;
COUNT(*)
----------
0
2016-10-17, 433👍, 0💬
Related Topics:
