Learn oracle - oracle tutorial - Oracle truncate table - oracle examples - oracle programs

What is TRUNCATE TABLE statement in oracle ?

• TRUNCATE TABLE statement is used to remove all records from a table in Oracle.
• It performs the same function as a DELETE statement without a WHERE clause.

Syntax:

TRUNCATE TABLE table_name;

click below button to copy the code. By - oracle tutorial - team

Copy Code

Example

TRUNCATE TABLE wikitechy;

click below button to copy the code. By - oracle tutorial - team

Copy Code

Code Explanation:

1. TRUNCATE TABLE represents the Oracle Statement .
2. Wikitechy is the table name which we want to truncate.
3. Click on the “Run” button to execute the given query.
4. The Records from the table has been deleted from the Truncate Statement.

Difference between truncate and delete:

• All the tables' rows, indexes and privileges will also be removed.
• No DML triggers will be fired.
• DROP and TRUNCATE are DDL commands,whereas DELETE is a DML command.
• Therefore DELETE operations can be rolled back (undone), while DROP and TRUNCATE operations cannot be rolled back.

This tutorial provides an indepth knowledge on the following items such as oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , mysql tutorial , sql tutorial for beginners , learn sql , oracle database tutorial , sql query tutorial , oracle dba tutorial , plsql tutorial , oracle tutorial pdf , oracle pl sql tutorial , oracle sql tutorial , sql tutorial point , oracle tutorial for beginners , learn oracle online free , learn oracle online , learning pl sql programming , learn sql online for free , sql learning online , dba oracle tutorial , oracle sql tutorial advanced , oracle 11g dba tutorial with examples , oracle online learning , oracle learning online , how to learn pl sql , sql coding tutorial , sql learning websites , sql basic learning