Oracle Delete Data

The syntax for Oracle to delete data in a table is:

Syntax structure:

DELETE from table name WHERE condition

Code Demo:

Sql> DELETE from Infos WHERE stuid= ' s100103 '; 1 ROW DELETED sql> COMMIT;

TRUNCATE

In a database operation, the truncate command (a DDL command) can delete all the data in a table at once, with the syntax:

Syntax structure:

TRUNCATE Table Name

Truncate and delete all can delete the data in the table, their difference is:
1, truncate is the DDL command, the deleted data cannot be recovered; The delete command is a DML command, and the deleted data can be recovered through the log file.
2, if the data record in a table is many, truncate relative delete speed.

Because the truncate command is dangerous, the truncate command is used sparingly in the actual development.

Oracle Delete Data