Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
How To Delete All Rows a Table
How To Delete All Rows a Table? - Oracle DBA FAQ - Understanding SQL DML Statements
✍: 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
2007-04-21, 4855👍, 0💬
Popular Posts:
How To Export Data to a CSV File? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If you wan...
What does XmlValidatingReader class do? XmlTextReader class does not validate the contents of an XML...
What is the method to customize columns in DataGrid? Use the template column.
Can you explain project life cycle ? Figure :- 12.2 Life cycle of a project There are five stages of...
How can you raise custom errors from stored procedure ? The RAISERROR statement is used to produce a...