Collections:
in Oracle
How To Delete All Rows from a Table in Oracle?
✍: FYIcenter.com
If you want to delete all rows from a table, you have two options:
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
⇒ Understanding SQL SELECT Query Statements in Oracle
⇐ Delete Multiple Rows from a Table in Oracle
2020-01-04, 3264🔥, 0💬
Popular Posts:
How to obtain the version number of the ICU (International Components for Unicode) library using the...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...