Toggle navigation
Log in
Sign Up
Log in
Sign Up
Appium
C
C#
C++
Docker
Go
Informatica
Java
JavaScript
Kafka
Numpy
Oracle
Pandas
PHP
Py Spark
Python
R
React Native
Scipy
SFTP
Tableau
Teradata
TGMC
UNIX
Forget_Code.Models.CategoryViewModel
Add a new snippet
Choose Category
TRUNCATE TABLE in Oracle
Forget Code
Oracle
TRUNCATE TABLE
The TRUNCATE TABLE statement is used to remove all records from a table.
It performs the same function as a DELETE statement without a WHERE clause.
SYNTAX: TRUNCATE TABLE [schema_name.]table_name
EXAMPLE:
TRUNCATE TABLE EMPLOYEE;
Removing rows with the TRUNCATE TABLE statement can be more efficient than dropping and re-creating a table.
Dropping and re-creating a table invalidates dependent objects of the table, requires re-granting object privileges on the table, and to re-create the indexes, integrity constraints, and triggers on the table and re-specify its storage parameters. Truncating has none of these effects.
Note: If you truncate a table, the TRUNCATE TABLE statement cannot be rolled back.
Tags for TRUNCATE TABLE in Oracle
oracle truncate table
truncate table
Contribute to Forget Code, help others.
Add snippet