Home >> Oracle >> Truncate table in Oracle

Truncate table in Oracle

Truncate table used to all data is deleted but schema remains, memory released and can not rollback.

Syntax

TRUNCATE TABLE tablename;

Example

TRUNCATE TABLE students;

 

Post Your Comment

Next Questions
Alter Table
Create table AS
Global Temporary tables
SELECT Query
INSERT Query
INSERT ALL Query
UPDATE Query
DELETE Query
WHERE clause
AND Clause
OR Clause
LIKE clause
IN clause
ORDER BY Clause
GROUP BY Clause
HAVING Clause
BETWEEN
EXISTS
NOT EXITS
ANY
ALL
MAX
MIN
AVG
COUNT

Copyright ©2022 coderraj.com. All Rights Reserved.