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 and Fusion Self Paced Training Videos by Industry Experts. Please Check oracleappstechnical.com
ReplyDeleteOracle 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