It is used to remove all the rows from table and save permanently in
database
It will not support where clause
Truncate = Delete + Commit;
Syntax:
Truncate table <Table_Name>;
Example:
TRUNCATE TABLE Emp;
TRUNCATE TABLE
Student;
Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.
ReplyDelete